Multi-Table Join Incorrectly Populating Portal
I have been struggling to populate a portal with a list of Invoice Items that are related to a License and to the current Client. This protal is in a layout that is showing records from the Client table.
For one client, the portal shows licensed items for all clients. For all other clients, the portal shows no licensed clients.
What am I doing wrong?
Abbreviated Table Layout
fClientID (related to Client::ClientID)
Invoice Item table:
fInvoiceID (related to Invoice::InvoiceID)
fItemID (related to Item::ItemID)
fLicenseID (related to License::LicenseID)
I've built some extra relationships trying to get this to work:
- Licensed Item (Licensed Item::fLicense = License::LicenseID)
- Licensed Invoice Item (LicensedItem::ItemID = Licensed Invoice Item::fItemID)
- Licensed Invoice (Licensed Invoice Item::fInvoiceID = Licensed Invoice::InvoiceID)
The portal is pulling from LicensedItem.
Software: FileMaker Pro Advanced 10
Update (2010-07-22): I've attached an image of the database's relationships. I've also added a relationship between Client and Licensed Invoice, as was suggested in this forum thread.