Hello, could someone please help? I have a database with a value list that is based on a relationship, when I choose data from one value list (1) it automatically looks up data from another database and in the second value list shows all the data that relates to the data in value list(1). The problem is that when I want to change value list(1) to something else the second value list still shows the same data until you click on it and choose the data you want.

for example:

value list(1) = Company

Value list(2) = Product

In company I choose McDonalds

In Product I choose Chicken burger

But then I want to change the company to Burger King

the product still shows as Chicken burger until I click on the product and choose what I want.

Is there any way of making the product value list show as blank when I change the company value list?

Thanks for any help, bit aof a strange question I know.

Chris.

You could try attaching a script to the Company field (where your first value list is). Then, anytime you clicked on the Company field to select your value from the value list the script would run and clear the Product field.

PS: I think this would require that the user actually click on the first value list rather than arrow down to their selection and hit enter. Otherwise the script won't run.