How do you create a Value List that only shows value related to the record your viewing? For example:

Table 1 has

A field labeled City that you type in the name of a city.

Another field labeled qualities is a pop-up list with qualities of that city.

So If I type in St. Louis in the city field, the options Arch, St. Louis Zoo, and so on would show up in the pop-up list in the qualities field. If I typed in Orlando instead, the options Beach, Disney World, and so on would show up in the pop-up list the qualities field. I assume I have to have another table with all the cities and there qualities. Thats no problem, I just don't know how to filter the pop-up list.

Thanks in advance

Yoo do need a related file/table to solve this.

The relationship should match on "City".

Create a local value list (in Table1).

1. Make the value list use "Use values from field" and click Specify

2. Select the relationship and the "qualities" field

3. Select "Include only related values"

This will restrict FMP to finding only the matching city records, and therefore only the "qualities"" associated with that City.

You might want to keep multiple "qualities" records in the related file, but you'll still only get the those that match the relevant city.

Ok, when I did that I get a pop-up list (in a portal) that automatically fills in multiple rows to show all the qualities. Is there a way to leave all the rows blank until I select the pop-up list in the row?

Anybody?

Perhaps this:

http://fmforums.com/forum/showtopic.php?tid/144255/

--sd