AnsweredAssumed Answered

Multi-Table Join Incorrectly Populating Portal

Question asked by BenGribaudo on Jul 21, 2010
Latest reply on Jul 23, 2010 by BenGribaudo

Title

Multi-Table Join Incorrectly Populating Portal

Post

Hello,

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?

Thank you,
Ben

----------------------

Abbreviated Table Layout

Client table:
ClientID
Name

Invoice table:
InvoiceID
fClientID (related to Client::ClientID)
Date

Invoice Item table:
fInvoiceID (related to Invoice::InvoiceID)
Qty
fItemID (related to Item::ItemID)

Item table:
ItemID 
Name
fLicenseID (related to License::LicenseID)

License table:
LicenseID
Name

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.

Table-Relationship.jpg

Outcomes