Jump to content

Relationship with a twist


elbokonon

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

Recommended Posts

  • Newbies

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 by Guest
Link to comment
Share on other sites

  • Newbies

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 :smile2:

Thanks.

Edited by Guest
Link to comment
Share on other sites

This topic is 6454 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.