Jump to content

value list include related values


Gillekes

This topic is 2798 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi everybody,

I have the following situation:

I have a product table. This table is related to a supplier table and each product can have many suppliers.

Now I would like to crate an order based on a supplier. when chosing the dropdown list the products to be shown should only be the products related to this supplier.

So I have an order table which relates to to the product table by means of line table (the order might have more than one product)

In the the order form I have a portal with the line table. The line table has a pop-up menu with a value list showing the products form the products table. Now I would like to be able to include the values only related to the supplier selected in the order table. 

Could someone help me how to create this relation?

 

Thank you for your time.

 

Gilles

 

Link to comment
Share on other sites

Well then assuming you have the following chain of relationships:

Products -< ProductSuppliers >- Suppliers -< Orders -< LineItems

you can define the value list to use values from Products::ProductID, include only related values starting from Orders.

 

Link to comment
Share on other sites

This topic is 2798 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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