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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem with multiple one-to-one relations
I have posted this question on the "Access - other" forum, but am trying it here also to see if I might find somebody who has seen this before. I am stumped. I have a "master" table with a primary key. There are two related tables with the same pk. If I create a query to...- virtualjm
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
-
Trouble with multiple one-to-one relations on a form
I would appreciate any help you could offer. I have a master table with a autonumber primary key called "PermitID". I have two other tables which also have a primary key of "PermitID" (long int), call them supplement1 and supplement2. The idea here is that the master table...- virtualjm
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Database design - looking for your opinion
Hello. I am creating a little application with Access, the task is basically one to fill out forms. Information like customer details, for example, will occur on more than one form so they will be stored in separate tables, in typical relational structure. But one caveat is that when any form...- virtualjm
- Thread
- Replies: 8
- Forum: Microsoft: Access Other topics
