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!
-
Foreign Key's not matching Primary
The reason I didn't make everything subforms is because of the way that would look. As for breaking things up into different tables, it just seemed more logical to me. I have done so on other dbs and have not had any issues. Originally this was working when i had it set up as an INNER JOIN...- soyring
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Foreign Key's not matching Primary
My DB has four tables: tblContact, tblPerformance, tblState, and tblComments. In tblContact there is a field (ContactID) which links all the tables together. It is a PK in tblContact and a FK in the other tables. I have form that has txtboxes to enter data in each of the tables. (Except...- soyring
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
