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