Pop up window with related records
I have a TT table, with fields Status, Company, PO and Date.
There's another table Order related with TT, with field Company, PO, Model, Qty, Price and Total.
The relationship between those two tables is: TT::Company=Order::Company, TT::PO=Order::PO.
Is there a to click on PO field in TT table, and then draw related information like Model, Qty, Price and Total from Order table and demonstrate them in a pop up window?