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)...
You are in luck. I created this relational database application a few years ago.
Even the names of the tables are almost the same. You have a few additional attributes (death date of the artist), but this is what you need to manage the data.
I see you included an attachment field, which is going to be a problem, most likely. Storing binary files internally in tables will cause the accdb to grow to an out of control size quickly. It's best to store images and song files (assuming that's what you have) externally and use links to the files.
Also, because these songs are typically on albums, you also need a separate table for albums. Link the artist either to the album or to a song, depending on how you want to enforce the rules.