AnsweredAssumed Answered

Many to many display in a portal

Question asked by CharlesBash on Apr 19, 2014
Latest reply on Apr 21, 2014 by philmodjunk

Title

Many to many display in a portal

Post

     I have a classic Many to Many DB issue.  Two primary tables (music and concert) and a join table with the music Id  and the concert Id as well as fields for the sequence in the concert and the soloist do this number in the concert.

     my problem is that when I build a display of the concert (displaying the music in a portal), the extra fields in the join table don't seem to be visible.   In other DB systems, I'd need to build a query as a pseudo table joining the "join table" to the other primary table.  Is thus the right FileMaker solution or am I just off base?

     (totally off list, I do know relational technology, with 30+ years of IT, so this is about how to use your system, not how to design a good relational system.)

Outcomes