It’s been quite a while since I designed a FM database, so I’m wondering if anyone can point me in the right direction here.

I’d like to use Filemaker to hold several large tables. From these tables, I’d like a single popup menu to populate layouts with subsets of each of these tables. For instance:

Colors Table:

Red Description ID

Green Description ID

Blue Description ID

Yellow Description ID

Sounds Table:

Sharp Description ID

Flat Description ID

Muffled Description ID

Loud Description ID

Layout 1:

[Popup Value A]

Color Portal:

Red (autopopulated from popup)

Green (autopopulated from popup)

Sounds Portal:

Muffled (autopopulated from popup)

Loud (autopopulated from popup)

Each related table record will be associated with one or more Popup Value, and must appear on the layout when the associated Popup Value is selected.

I’d like users to have the ability to enter the Layout, select a Popup Value, have the Layout autopopulate with the table items associated with that Value, and be able to associate & disassociate records from several tables with that Popup Value (preferably without leaving that Layout).

Since each table item (there will be thousands of them) might be associated with multiple Popup Values, I’m having trouble with constructing a relationship which will allow this.

Any help would be greatly appreciated,

Thanks!

Layout 1:

[Popup Value A]

Color Portal:

Red (autopopulated from popup)

Green (autopopulated from popup)

Sounds Portal:

Muffled (autopopulated from popup)

Loud (autopopulated from popup)

That one chosen popup value is associated with both Red & Green and Muffled & Loud?

Seems to me - if I understand it correctly - that you need a "popup values" table and a join table between that and the Color and Sound tables.

Each popup value can have many Colors. Each Color can have many popups associated with it