Relationship between Client, Order and OrderItems

[edmonton]

Hi I have three tables: Client, Orders and OrderItems. One client can have many orders and one order can have many OrderItems. Very simple relationship, right? Problem: I am trying to create a layout in which you select a Client and all the orders for the client show up in a portal setup. I am doing the following to achieve this: 1. New layout with only a body, no Header 2. Layout table is Client 3. Client field from Client table with a drop down list showing all the clients 4. Portal of Orders table. Displays data from Orders and OrderItems When I select a client from Clients drop down list, no data shows up in the Portal for that client. I know there are orders for the client. Why is this happening ? Any help will be greatly appreciated. I am using FM v11. Thank you

[MetaSys Software]

Hi

 

Please find the attached file where we have implemented as per your requirement.

 

on which field the dropdown list you ceated is based on? I think it should be a global field and the relationships based on this field. We have done in the attached file.

Test_DB.zip

 

Thanks

[edmonton]

Hi

 

Thankyou for your reply. I cannot open your file as I use FMP 11 and not 12. If you can, please upload your example in FMP v11 so I can view it.

 

Thanks

[MetaSys Software]

Hi,

 

Sorry for the late reply.

Attached is the file in FMP 11. Let us know in case of any queries.

 

Thanks

Test_DB_v11.zip