I am back to working in FMP after a multi-year hiatus, and I am rusty and am currently stuck. Hoping someone can point me in the right direction. I hope I am posting in the right topic.
I am building a solution where we have a number of many-to-many relationships that are being used via portals.
This is the issue that I am having that I am stumped on.
In this instance I have the following db graph:
Workshops <--=--> WorkshopStaff <--=--> Staff
Each workshops may have multiple Staff and Staff may participate in Multiple workshops
On the Workshops layout I have a portal to WorkshopsStaff
In order to add Staff to the Workshop I have a button that brings up a popover with a portal that lists all Staff from which to select. I can select a Staff Member and they get added to the WorkshopStaff table.
This popover was more or less modeled on the "invoices" starter solution
The way I am displaying the portal inside the popover is via a table occurrence like this:
Staff <--X--> StaffList (Cartesian relationship)
My issue is that the portal in the popover (the result of the cartesian relationship) displays and works as intended as long as I have one related entry in the WorkshopClient table.
But for a new Workshop for which I don't yet have any entries in the WorkshopClient table the portal in my popover comes up empty.
What I am doing wrong or is there a better way to populate the list from which to select staff?
Thanks a bunch.