Nestor Posted November 3, 2011 Posted November 3, 2011 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 Posted November 4, 2011 Posted November 4, 2011 Search the forums and web for conditional value lists. You'll need to create tables that contain the related data for the value list. 1
Nestor Posted November 4, 2011 Author Posted November 4, 2011 Thanks VAUGHAN.... that's found exactly what i was looking for.
Recommended Posts
This topic is 4784 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 accountSign in
Already have an account? Sign in here.
Sign In Now