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.
The maintenance table is called Maintenance_table
The equipment table is called Equipment_table