Portal Relationship Help

[arbelbedak]

Hi Everyone,

I need some help with a portal I am setting up. I have a table of Music Albums and every album can potentially have up to 4 different publishers. In turn, there are 4 different publisher fields, all with drop down menus that populate from records in the Publishers table. I set up multiple instances of the Publishers table, one for each publisher field in the Music Albums table. I have created a portal in the Publishers database to display all of the Music Albums that a given publisher owns, however it only shows a music album if the publisher is labeled in the Publisher 1 field on the music album table. How can I get the portal to show all music albums related to the publisher (from any of the 4 available fields)? I think this might result in a many to many relationship, so perhaps there is a middle table that needs to be created?

Thanks for your help!

Arbel

[eos]

so perhaps there is a middle table that needs to be created?Arbel

Exactly, aka a join table; define foreign key fields to combine in each record a Album's primary ID with a Publisher's primary ID. Then from Publisher look through the join table into Albums to see all album by a given publisher, or from Albums to see all involved publishers - all in one portal, respectively. A join table lets you make any number of combinations, not just 4, and allows you create fields like publishing date etc. without having to multiply them in the albums table.

Here's a link to a Knowledge Base article on the FileMaker, inc. website, which shows how to set up a join table:

http://help.filemake...n-filemaker-pro