Conditional value list

[ianmuir]

I have a conditional value list as on my attached picture, which is very simple and shows a company and their products.

I pick a company and the next field shows the products for that company. This works well.

 

Companies table holds the company name and the products, order table displays the company name and lets you select the product.(Item).

 

I need to display another company and product on the same layout so i have 

 

Company      Product

Company 2   Product 2

 

The all must work of the same companies table so i can display 2 separate companies and products on the same layout.

 

Hope this is clear enough.

Any ideas?

 

 

 

 

[Wim Decorte]

No picture attached, but from your description a few things are off:

 

- products and companies do not belong in the same table

- the layout sorta feels like an Order where you can pick products from different companies?  That should not be done from the Companies context.  If it is order entry then Orders is its own table

[ianmuir]

Yes it is picked from the orders table on a layout.