Conditional Value Lists

[Jason Goldsmith]

I am trying to create conditional value lists based on State, City, and Restaurants. I got it working so that if I choose a state, then the next value list limits cities to those within the chosen state. But I can't get the the third value list (restaurants) to be limited to those within the choosen city. I have attached a copy of the file. Thanks for your help.

[Jason Goldsmith]

I'm trying to figure out why my attachment doesn't work. I'm using DropStuff. I'll try again.

[Jason Goldsmith]

With the attachment

[Fenton]

This works. It's still a little confusing, because both your value lists are named "city," and the main table is named "state"; which can't really be right. But I left the names as is.

ConditionalValueList_4.zip

[Jason Goldsmith]

That works. Thanks Fenton.

[Pacer Print and Packaging]

What if want add more than 3 categories/fields? The example listed here uses:

1. State

2. City (conditional value list. values shown dependent on the chosen state)

3. Restaurant (conditional value list. values shown dependent on the chosen city)

The above example works if the city is only assigned to one state.

I have a case where a value list would match multiple values from the preceding list.

My fields (with sample data)

1. Category

--Business Cards

--Envelopes

--Letterheads

2. Description

--28lb Bond

--32lb Cotton

--80lb Cover

3. Size

--8.5x11

--8.5x14

--11x17

4. Colors - Side 1

--1

--2

--3

--4

5. Colors - Side 2

--1

--2

--3

--4

6. Quantity

--100

--500

--1000

--1500

7. Price - The price chosen is dependent on all of the preceding choices.

etc....

My price list table has 11,792 records and I am having a problem making a conditional value list with 6 levels.