Foreign keys and composed keys

[ak48]

Hi, I am new to the world of access and I want to know the way to create foreign keys and keys that are composed with more than one field. Thanx for the help.

 

[Magnetar]

Hi there!

Very briefly...
For a Composite key: In the Design View of your table, you should be able to highlight & select two fields for example, (using 'shift' key or your mouse), and then selecting the yellow 'key' symbol from the menu.

For your Foreign Key: This will be a Primary Key in a previous table to which you will want to link your current table to. (Refer to the help menu in the database window.

Best wishes

Magnetar

 

[Magnetar]

Hi there!

Very briefly...
For a Composite key: In the Design View of your table, you should be able to highlight & select two fields for example, (using 'shift' key or your mouse), and then selecting the yellow 'key' symbol from the menu.

For your Foreign Key: This will be a Primary Key in a previous table to which you will want to link your current table to. (Refer to the help menu in the database window).

Best wishes

Magnetar

 

[ak48]

That was very brief, but that's all I needed. Thanx a lot!