add multiple records

B

bookworm

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?
 
O

Ofer Cohen

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
 
Top