Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Choosing correct column in table for accurate query results
OK - So I have very little experience with Access, but I've been given this project: I have to create a database of various government offices which will then be searchable by the state and county of jurisdiction. At this point, I've created the following tables (Table names are indicated by a...- cmcollins
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
-
Limiting choices in a junction table
This is sort of a complicated question, but one which probably has a very easy answer... I'm making a database of contacts; each contact is associated with multiple counties in the US, and each US county has more than one contact associated with it. I've made a junction table with two...- cmcollins
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
