Circular Relationship

[Siva D]

Hello Guys,

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

 

 

Circular_Test.zip

 

 

 

I want to to filter records in Vendor_Items by vendor_id from PO table and Item_ID from PO_Lines table. I have attached the database.

Any help would be apprciated.

 

Thanks,

Siva

 

 

[doughemi]

You need a new TO of the Vendor_items table

 

NotCircular_Test.fmp12.zip

[Siva D]

Doughemi,

Thank you for your quick reply.

 

But i do not get expected result. Please look at the attached DB.

 

Circular_Test_Re.zip

 

In the PO layout, As per your graph 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..

 

Please help.

 

[doughemi]

I think this is what you are asking for.  If it is not, please describe the business task that you are trying to model, using some real-world terms.

 

Circular_Test_Re_2.fmp12.zip

[Siva D]

Thank you Doughemi.

 

This is the result what i wanted.

I thought, there is a way to get this result without creating additional field (Vendor_ID) in PO_Lines.

 

Thank you for your efforts.