Forum Discussion
Linking tables using relationships
Hi All, Just got a minor problem with an access database that I am creating. I have two tables, "Song" and "Artist". For some songs there are multiple artists, so in the Artist_ID field (Foreign Key)...
Agree with previous comments about avoiding attachments and multivalued fields.
You might find my 3-part article useful: Relationships and Referential Integrity
It also includes an example on albums and album tracks.