![compound key - Access 2010: How to Handle Compund Primary Keys in Datasheets and Forms - Stack Overflow compound key - Access 2010: How to Handle Compund Primary Keys in Datasheets and Forms - Stack Overflow](https://i.stack.imgur.com/E0E4S.png)
compound key - Access 2010: How to Handle Compund Primary Keys in Datasheets and Forms - Stack Overflow
![database design - Composite primary key plus a separate (surrogate) id column for foreign key references - Database Administrators Stack Exchange database design - Composite primary key plus a separate (surrogate) id column for foreign key references - Database Administrators Stack Exchange](https://i.stack.imgur.com/2zyB0.png)
database design - Composite primary key plus a separate (surrogate) id column for foreign key references - Database Administrators Stack Exchange
![sql server - Identity versus Composite values for Primary Keys in Many-To-Many Tables - Database Administrators Stack Exchange sql server - Identity versus Composite values for Primary Keys in Many-To-Many Tables - Database Administrators Stack Exchange](https://i.stack.imgur.com/UmyGA.png)