Create relationship between multiple field primary key and anther table

[mountainclimber]

In table 1 fields Factor, Aggregations, Stat, and Days Back are fields that make up a multi-field primary key (https://www.youtube.com/watch?v=6yjpd8yb6_Q).

I want to create a relationship between that multi-field primary key and another table, call it table 2, and make it a one-to-one relationship.

How do I do this in MS Access 2013?

[orange]

Relationships are based on your requirements. That is the data and how they relate to each other in "business". You don't arbitrarily say, " I think I'll join X to Y as 1 to Many".

Multi-field primary keys (often called compound or composite primary keys) are fine. The issue (based on your related post) is highlighted when you have another related table and you have to repeat the all of the keys. It can get somewhat complex and unwieldy. The workaround/alternative is to use a surrogate primary key, and then make a unique composite(compound) index of the fields you originally had in the (multifield ) Primary key.

[mountainclimber]

Relationships are based on your requirements. That is the data and how they relate to each other in "business". You don't arbitrarily say, " I think I'll join X to Y as 1 to Many".

Multi-field primary keys (often called compound or composite primary keys) are fine. The issue (based on your related post) is highlighted when you have another related table and you have to repeat the all of the keys. It can get somewhat complex and unwieldy. The workaround/alternative is to use a surrogate primary key, and then make a unique composite(compound) index of the fields you originally had in the (multifield ) Primary key.

got it thanks!

[June7]

I agree. I vigorously avoid compound PK. Can use autonumber as PK and set other fields as compound index to prevent duplicate combinations.