If I have a master table where I have "Autotypes" as primary key and I have a second table with the primary key colors "Colors". I want that an autotype never has a duplicate color, but two different autotypes can have the same color. How do I get this to work?
Solved How to connect two primary keys
- Thread starter cheberdy
- Start date
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Tomorrow, 04:08
- Joined
- May 7, 2009
- Messages
- 20,746
you add another field (long integer) to your second table.
this will serve as it's Foreign Key (refering to your first table, pointing to it's Autotype field.).
the New field should write the Autotype value of the first table.
create a relationship between your tables.
this will serve as it's Foreign Key (refering to your first table, pointing to it's Autotype field.).
the New field should write the Autotype value of the first table.
create a relationship between your tables.
Sorry I forgot, it should then produce all possible records
maybe in a Query?
Similar threads
