Value list based on field contents?

[Davidatlamont]

I'm fairly new to FM, so please be patient.

Is there any way to stipulate a value list based on contents of another field?

I have the following:

Field- Regions

Field- Stores

Each region has different 'stores' associated with it. If I creat a value list for field "stores" it will contain hundreds of entry's and will be difficult for user to find/select appropriate "store".

Since each region only has about 15-20 stores associated with it, I would like to have different value lists of "stores" for different "regions". Question is whether there is some way to display appropriate value list based on contents of field-"regions".

Example- If I choose region "west" I want to see one value list for "stores", but a different list if I choose region "east".

Hope this makes sense. Any way of accomplishing this? Better way?

Thanks.

[Jacob22x]

If you set your database up so that you have two tables, "Region" and "Store", and you relate them to each other (so each store record will have a "RegionID" field that links it to the correct region), then you can create a value list based on "Store" and choose to restrict it by region. Just go to File -> Define -> Value lists, choose new, pick Define values based on field, then click "Specify Field" and click the bottom left "Limit values based on..." (This is assuming you're running off a Mac, though I'm sure it's similar on windows.) That should get you started.