Music database

[jmt2005]

I wonder if anyone can help - i'm fairly new to access and am just starting to plan a database to catalogue my CDs. I've looked at the microsoft template and various others. Anyway, everything is fine until you get to a "various artists" CD and i'm a bit lost now about my table designs and relationships etc. can anyone help me with the best way of going about this?
Thanks in advance

 

[Len Boorman]

Send me a PM with your email address. I have a database that I created for a friend who is a part time DJ, so its a bit industrialised.

Covers multiple media, cd,tape,vinyl
Same track different artists options
Search by Track name, artist, all sorts

Quite good even if I do say so myself.

It does actually get quite complex as you will see

Len

 

[ScottGem]

I wonder if anyone can help - i'm fairly new to access and am just starting to plan a database to catalogue my CDs. I've looked at the microsoft template and various others. Anyway, everything is fine until you get to a "various artists" CD and i'm a bit lost now about my table designs and relationships etc. can anyone help me with the best way of going about this?
Thanks in advance

This is a many to many relation. So you need a join table to join artist to CD.

tjxArtistCD
ArtistCDID (PK Autonumber)
ArtistID
CDID

 

[jmt2005]

Thank you both for your help.
jules