Setting multiple Value List?

[Mitesh]

Hi,

I have got customers where each customer can have many divisions and in each divsion customer can have many contacts.

I have attached the zip file for the purpose.

When the application is run you will be able to see 2 customer records.

My problem is when i click on Add New contact it displays the contact layout but in the division drop down it does not show the divisions for that particular customer. Even if i select the Division it does not display the name of the division in the text box.

Could anyone can have a look and point me in right direction. I desperately need to get this sorted out.

Thanking you in advance.

Mitesh

Jackie.zip

[Simon K]

You first need to re-define your value list for "Divisions" so that it instead of including all values you only include values starting from the related table "Company".

The value list will then show the division names for that company (I would also be inclined to only show the second value).

If you change the "drop down" to a "pop up" menu it will show the text for the second value but still store the first value ie the division id in the field - slightly easier on the eye.

If you still want to use the division name in the "text box" you need to add another table occurrence of "divisions" and link it to the contact table on the division ID fields. You do this from the manage database window, relationships tab.

You then need to change the division name field as you currently have it to pick up the division name from the newly linked table occurrence of divisions.

See attached

Jackie_rev1.zip

[Mitesh]

thanks simon,

i will try your solution when i get home.

[Mitesh]

Simon,

Your solution works like a dream. Thank you.