Many to many display in a portal
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.)