Defining composite primary keys
From Morfikwiki.com
Contents |
[edit] Introduction
Some times you need to define a primary key that is a combination of two fields. This is called a primary composite key.
[edit] Part 1
To define a composite Primary key,
- open up the Table Designer,
- right click on the first field and select "Primary key",
- right click on the second field and click on "Composite Primary key".
You should now see two key images next to the two fields which indicates that they form a composite primary key.
