combined prime key

[ugly]

My prime key in table A consists of 3 fields. Table A has a 1 to many relationship with table B. One entry in A links to many in B. I want to join the two tables, do I need manually enter the three fields that form the key in A, into table B or is there a quicker or more obvious way of doing this?
Thanks for any guidance

 

[r937]

yes, if table A has a 3-column primary key, then table B will have a 3-column foreign key, and when you create a query which joins them, the join condition will have three equality comparisons

r937.com | rudy.ca