Value List Question

[Nestor]

Hi,

I'm trying to create Drop downs that only pull the info that corresponds to the previous field. Meaning.

I have 4 Drop Down Fields and want to be able to click on the first drop down and only See "Girls", under the second drop down i want to see "T-Shirt", under the 3rd drown dow i want to see "A,B,C" and under the 4th dropdown i want to see only the fields that pertain to the 3rd field. Meaning if i select "A" i want to see on my 4th dropdown "3710" and "3900", if I select "B" i want to see "8000" and if i select "C" i want to see "1300" and "1400".

How can i make this happen. Please see attachment. its the last Value List that's giving me trouble.

I'm planning on adding 1000 records with different Items and vendors, but don't want to add any data until its right.Sample.zip

THanks.

Product Cat Vendor Item Girls T-Shirt A 3710 Girls T-Shirt A 3900 Girls T-Shirt B 8000 Girls T-Shirt C 1300 Girls T-Shirt C 1400

[Vaughan]

Search the forums and web for conditional value lists.

You'll need to create tables that contain the related data for the value list.

[Nestor]

Thanks VAUGHAN.... that's found exactly what i was looking for.