Jump to content

Conditional Value Lists


This topic is 6980 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

This topic is 6980 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.