Hi all

I would really like some help with this and I will make it as clear as I can!

I have two tables, the first is an equipment table which contains inventory details of various pieces of equipment!

The second table is a maintenance table which contains maintenance history of the equipment.

I would like to place a hyperlink in the equipment table detail view (first table) that opens a new window or popup window and displays the maintenance history of that equipment in a filtered table view .
i.e. just the maintenance records for the particular equipment currently displayed in the initial equipment detail view.

The tables are linked by the equipment tag field NG_number i.e.
<%%VALUE(NG_number)%%>

The maintenance table is called Maintenance_table
The equipment table is called Equipment_table

Please help

Regards
Eddie

Maybe this page will help if you did not read it yet.
http://www.websitedatabases.com/filters.html

You could define these filtered results, save the filter and place as link(s) for pre-defined filters in your header.php or footer/php file.

I think save filters will only be displayed if you enabled filters in your project file.

I found it so easy to send the variable results through the browser URL! but thanks for the tip!

Eddie

How exactly did you send the results through the url?