special problem

[Enno]

Hi,

i have a database containing the fields: company, name and phone.

on the searchform i want to have a dropdownmenu containing all firms. That is no problem - i can use a valuelist from company.

But, the second dropdownmenu should contain now a list of all name in the firm that is selected. I.E. show all names in the list where the firm = 'first selection'.

Then show me a list of the phonenumbers.

Could someone give me a hint how to realise it?

Bye Enno

[This message has been edited by Enno (edited November 29, 2000).]

[dspires]

When you specify the field to use in the value list there is an option to have it use only related values.