Jump to content
Sign in to follow this  
Siva D

Circular Relationship

Recommended Posts

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

 

post-108240-0-62287800-1360991877_thumb.

 

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

 

 

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.