Can you make columns dependant on each other?

[Funkbuqet]

Is there a way to make the values displayed in a combo box change depending on the value in another combo box? I have seperate columns for county and city and after you select the county I want it to only dislay cities in the selected county. Thanks for the help.

 

[boblarson]

If you are talking about lookups at the table level - NO and you shouldn't be using lookups at the table level. You use them on FORMS. See here for why lookups at table level are EVIL.

 

[Big Pat]

Bob's answer is true, but as an amateur who's had TONS of help from Bob and others over many years now, it strikes me that perhaps it doesn't completely answer your question.

I think what you need is what's referred to as a "cascading combo" (which would, as Bob says, be used on a Form and not in a Table). Do a search on this forum for that term. It tok me a while to get my head around the concept, but when the penny finally drops you'll see it's actually pretty simple.

Good luck!

 

[Funkbuqet]

Thanks a lot for the info. You may have saved me from making a grave error.

 

[John Big Booty]

See this post for a sample and explanation of cascading Combo boxes.