I am new to Filemaker and hope somebody might be able to help me.
I am creating a database of song compositions, songwriters, ,recorded tracks, artists, producers and albums etc.
I attach some screenshots that shopw my tables, relationships and some of the layouts.
I am trying to create a portal in my Albums layout that shows all the recorded tracks and the artists on each track.
In my tracks layout, I used LIST to show in a calculated field all the artists on one particular track. BUT when I try to show this same calulated field over on the Portal I have created on my Album page, it simply does not work. No Artists show up!
I'm pulling my hair out trying to figure this out. Either there is a realtionsjip wrong somewhere, or I am asking the portal to do something it cannot do (display data from a different related table).
Can anyone out there help me solve this conumdrum... I've only had Filemaker for two days so please excuse me if I'm not explain the problem well.