Reply to thread

Message: [QUOTE="Gnowor, post: 2571033"] I'm an Access newb and freely admit it. Usually I can pick stuff up pretty quick but Access is baffling me. When i say checkboxes, I mean each Zip code is a Yes/No field, and each city is a yes/no field, in two separate tables. Both tables have a field that Agent ID number, which is related to the Agent ID in the Agent info table. Hope that's enough info. The end result is that I want to be able to look up all the info on all the agents that cover a specific city or zip code. Perhaps there's a more efficient structure that I've overlooked. Hope that's enough info. [/QUOTE]