Jump to content

Related Value Lists


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

Recommended Posts

  • Newbies

Hi,

Situation:

I have a value list with 5 countries

(United Kingdom Germany France Denmark Switzerland)

When I select the appropriate country, ie Germany, I want only the cities in Germany to appear in the cities Field (check box formatted)

Does this make sense? Is it possible to dynamicaly bring up the Germany City Value List?

Any help for a new user would be appreciated.

Regards,

Chris

Link to comment
Share on other sites

If you're using FMP5, then the ability to have a menu show only related data is built into the software.

First you need a relationship that will have related cities when the country is set. This could be an extra file (or one you already have) that has records for each city, with the country the city is in.

The file you want to have the menu in needs to have a country field, and a relationship needs to be created between the two with the country field of both files as the match field.

Then in the file you want to have the menu in, create a value list called Cities. Choose "Use values from field:" and specify as your file the file with the cities. Click on "Only related values" and choose the relationship you created. Then click on the Cities field of that file.

If you're not using FMP5, but are using either 3 or 4, then you need a workaround technique. There are many to choose from. Check out www.databasepros.com for a bunch of references. Search for hierarchal menus.

Chuck

Link to comment
Share on other sites

This topic is 8094 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
 Share

×
×
  • Create New...

Important Information

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