Help!!! Having trouble displaying related records
Any advise would be really appreciated.
I have 3 tables: shot, bid and bid line
On a layout displaying records from the 'shot' table, I would like to have 2 portals 1) 'bid' and 2) 'bid line'. There will be multiple 'bid line' records for each 'bid' record. Is there a way of displaying (and creating) in the 'bid line' portal, records that are only related to the current selected 'bid' record. 'Bid' and 'Bid line' are related via the bid serial number.
See attached - 'Bid' is on the left and 'Bid lines' is on the right.