FM7 Relationship Newbie Question

[osninc]

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