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

Thanks Ralph! that works perfectly

Hi, I have a FM7 DB that is simulating inbound mobile phone call transactions coming from various wireless carriers. I need a script or calculation field that can automatically populate a field at the time of record creation named CARRIER_NAME. The catch is I need to do it randomly yet over time I need to adjust it for relative market share percentage of each wireless carrier. I have 2 tables:CARRIERS & TRANSACTIONS. The CARRIERS table has just 7 records listing the names of the top 7 US wireless carriers in the NAME field and market share in the SHARE field. The TRANSACTIONS table has a TIMESTAMP field indicating the time of the simulated call and the CARRIER_NAME field which is what I need to be populated randomly with data from the NAME field from one of the 7 records in the CARRIERS table yet weighted based on the SHARE field. Does anyone have any ideas on how to do this in FM7? Thanks in advance for your help. Tim J.

Hi, I have a FM7 database with 4 tables: AGENCY BRANDS CAMPAIGNS AD CODES I am trying to create relationships between all of these tables based on a numeric ID field in each table i.e. AgencyID, BrandID, CampaignID, AdCodeID. I understand the idea of a 1 to many relationship somewhat from MS Access but am not sure how to do it in FM7. I need an AGENCY realted to many BRANDS which are related to many CAMPAIGNS which are related to many AD CODES. Every time I try it I may get the wrong related table that will have the chevron/crows feet indicating that it is the "many" side of the relationship rather than the one "side". Then, assuming I can get this working, is it possible to display all information on 1 layout for AGENCY through multiple portals or nested portals? I'd like to be able to see on 1 layout all BRANDS related to an AGENCY and when I click on a BRAND in a portal row it displays a sub portal with all CAMPAIGNS related to that BRAND and then when I click on a CAMPAIGN in a portal row it displays all AD CODES related to that CAMPAIGN. Am I asking to much of FM7 or do I need to go back to the middle ages and MS Access? Thanks in advance for your help. Tim