More than one path in relationship graph
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.
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.