Relationship with a twist

[elbokonon]

Hello,

I understand the basics of building a relationship between two tables in the same file.

My project:

1. One table has country/location entries (Costa Rica, USA, etc.)

2. Another table is used for data entry. Would like to select country via drop-down in this table , and have the appropriate locations displayed as drop-down list.

In effect, I believe it's a relationship returning a list of values rather than one distinct value.

Any insight would be appreciated.

Sarge.

Edited September 17, 2006 by Guest

[Genx]

Have a search for conditional valuelists on the forum.

[Genx]

3 Links that might help you:

http://www.fmforums.com/forum/showtopic.php?tid/177787

http://www.fmforums.com/forum/showtopic.php?tid/177731

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

[elbokonon]

Thanks, the links solved my problem.

I did encounter an interesting problem. After building the conditional list, if I changed the "location" of one record (within same country), then all the records of that "country" were switched to the new "location."

No clue why that was happening... :qwery:

But a redesign of one of your examples solved the problem

Thanks.

Edited September 19, 2006 by Guest