Hi everybody,

I've followed a few tutorial on how to make a conditional value list and I made it happened once but for some reasons, I'm not getting why I can't get the second one to work.

I have a few tables ready:

Main_Category table

Sub_Category table

Customer Table,

Order Table

Order_line Table

Basically, A client can either be from a choice of 2 categories (A or . When I create an Order, I want a pop up for the product that will only display the sub_category according to A or B.

In other terms, let's say the 2 categories are N. America and S America and sub categories are Canada, and USA for category N. America and Argentina, Bolivia, and Brazil for category S America, I wanna make sure that when I create a new order, if the client is from S America, the only choices available will be Argentina, Bolivia and Brazil in the order layout.

So far,

1/ Customer table is linked to Order table using Customer_ID field

2/ Order table is linked to Sub_category table using Sub_cat_ID field

3/ Order table is linked to Orderline using sub_category_ID field and Invoice_ID

I hope you guys can help me establishing the proper relationships.

Thanks

davidoz,

I have created a very simple file to show you how it has been down. I can not explain now but if you are still having problems let me know.

David

joined lists.zip