This video tutorial (less than 2 minutes) explains the very basics of what Microsoft Access relationships are focusing on the foreign key and where it can be used.
Microsoft Access Relationships With Foreign Keys
Microsoft Access Database – My Thoughts About Microsoft Access Relationships With Foreign Keys
Using the foreign key can be used in several ways not just as the video tutorial demonstrated. It’s also used to mark any field in a table to be indexed for your Access formula query calculations and setting criteria too.
When dealing with Microsoft Access relationships, you are now applying indexing too which speeds up your queries and reports. The foreign key is indexed as ‘Duplicates OK‘ in the property settings from the design view of an Access table.
Want to learn more about Microsoft Access relationships? Take a look at my eBook on Understanding Access Database Relationships (RDBMS) – Joining Tables.
Tags: foreign keys, microsoft access relationships, MS Access, ms access records, relationship database design, relationships in databases
Using primary and secondary (or foreign) keys are often over looked which can help with running and sppeding up your reports.