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)...
Sorry, but the link you provided does not seem to work. With this being a small scale project, the attachment fields (Pictures) are not going to be a issue, and I am not attaching the song files. My Full Database has 5 Tables; Album, Artist, Band, Record Company, and Song. All of the relationships are fine, apart from the Artist Song relationship, as I have some songs, like the Rolling Stones songs, that have two artists working on them.
"Sorry, but the link you provided does not seem to work"
Please be more specific. What DID happen? If I know the problem, I can fix it.
I would not be too confident in the use of internal attachments of binary files. That's long been a trap for newer Access users.
I have an alternative location for downloads, perhaps this one will work better for you. Search this Public OneDrive for MusicandArtist.
It illustrates the many-to-many relationship you need and the preferred table design to support it.
- The link that you did provide only reloaded this forum page. There were two zip folders I found under MusicandArtist, but when I opened them, I could only view the switchboard. Is there something else I need to do?
I got the link wrong.
Sorry.
The demos are full working sample databases. You have to look at them in design view to see how they are put together. Look at the relationship diagram and the forms and subforms and the code behind them.