August 6, 200421 yr Newbies 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
August 6, 200421 yr I would place a button on your portal rows, attach a script that would set the field of your other portal relationship. Tina Marie
Create an account or sign in to comment