Create Database - Music Singer, Artist. view information and add notes to it

[ShannonJM1983]

Very new to Access. I need to create a database.



I have a list of singers who i can search for based on Nickname or First/Last name. I have a range of details about each singer.

I have a small list of Albums that each singer has created. I have a range of details about each album.

I want to select a singer and generate a form where the top half of the form lists the singer along with all of their details. I want a box attached to the singer where i can write personal notes about the singer which i can continue to add to over time. On the bottom of the form i want to have a drop down menu where i can select one of the singer's albums and then see details about that album and have a box where i can write notes about that album which I can add to over time. On the form I want the option to be able to add an additional album along with its details when a singer releases a new album.

I also want to create a separate form and use that form to insert a new singer into the database.

Any help for how to start this would be great.

Shannon

[ranman256]

You need tArtists and a tGroups table and a tGroup members.
Eric Clapton was in many groups, so his ID would show in tGroupMems several times.

tGroups tbl
--------
GroupId (auto)
GroupName

tGroupMems
------------
GroupID (long)
ArtistID (long)

tAlbums tbl

[orange]

There are some links at this site that may be helpful in planning/designing your database.

Welcome, and good luck.