AnsweredAssumed Answered

More than one path in relationship graph

Question asked by dsivaa on Feb 16, 2013
Latest reply on Feb 18, 2013 by dsivaa

Title

More than one path in relationship graph

Post

     Hello Experts,
     I am new to filemaker. I am making an inventory database.
     I have a problem in making relationship with three tables. Filemaker saying more than one relationship path is not allowed.

PO
     PO_ID
     PO_Date
     Vendor_ID
     Vendor

PO_Lines
     PO_ID
     Item_ID
     Item_Name
     Qty
     Price
     Amount

Vendor_Items
     Vendor_ID
     Item_ID
     Price

     When i try to use another occurance of the table Vendor_Item,
     In the PO layout, i get either Item_Id filtered or Vendor_id filtered.
     If i use Vendor_Item in the portal, it filters only Item_ID.
     If i use Vendor_Item2 in the porta,l it filters only Vendor_ID

     I need to filter both Vendor_ID (from PO table) and Item_ID (from PO_Lines table) in Vendor Items portal..
     Any help would be appreciated.

circular.JPG

Outcomes