add multiple records

[Guest]

I need to create a table that contains a music album and all tracks on it.
The data entry will be through a form. How can this be done so that I am not
typing the album name each time, but just the track name?

 

[Guest]

You need to create two tables
1. Music album
2. Tracks

the form you create contain a sub form
Main form Bound to table1 and list the Music Album
Sub Form bound to table 2, Tracks

That way you don't need to retype the Album again, and it's the right
Normalize data. There is no need to store the Album name again.

Look at this link, there are few more links there about normalising data

http://www.databasedev.co.uk/1norm_form.html

 

[Joseph Meehan]

You need to create two tables
1. Music album
2. Tracks

the form you create contain a sub form
Main form Bound to table1 and list the Music Album
Sub Form bound to table 2, Tracks

That way you don't need to retype the Album again, and it's the right
Normalize data. There is no need to store the Album name again.

Look at this link, there are few more links there about normalising
data

http://www.databasedev.co.uk/1norm_form.html

You likely should have a Artist table as well, linked to the Album
table. You may also want to consider type (opera Rock&Roll, etc.)

Using related tables not only allows for easier input and a better
design for Access.