Synchronizing 3 portals on 1 layout

[osninc]

I have a FM7 database with 4 tables: AGENCIES, BRANDS, CAMPAIGNS and CODES. The relationships are the following: AGENCIES can have multiple BRANDS. BRANDS can have multiple CAMPAIGNS. CAMPAIGNS can have multiple CODES.

I have a single layout named Agency and it has 3 portals: Brands, Campaigns and Codes laid out vertically. How can I synchronize/filter these three portals based on the portal and portal row I click on? For example if I click on row 2 of Brands I only want to see only the Campaigns related to that particular brand in the campaign portal. Then when I click on a Campaign portal row I only want to see the codes associated with that campaign in the Codes portal.

Does anyone know how to do this in FM7?

Thanks,

Tim

[Tina Marie]

I would place a button on your portal rows, attach a script that would set the field of your other portal relationship.

Tina Marie