Sub Form

  • Thread starter Thread starter Andrew C
  • Start date Start date
A

Andrew C

Hi

I am not an advanced user of access but i know my way
around a little and learning more as i go. Thanks to
Microsofts Newsgroups.


My latest problem is. My CD Collection is really big and i
started to create a database to record the CD's.

I have a form that has the name and year released,
how ,many discs and so forth at the top. Underneath it i
have a sub form to display the tracks of the CD. (No
problem So far) I now want to create another sub form
underneath it to display the singers of each individual
tracks (i have a few compilations) but not sure how to do
it.

I have had a few attempts but it keeps listing all of the
singers on the album instead of the one track.

Can some advise me what to do.

Thanks

Andrew
 
Andrew,
If your subform with the track title is working then you're 99% of the
way there
The CD information (Title, Name, Artisy, ertc..) are the ONE portion of
your data realationship... the Track information is the MANY portion... and
you say you've got that in a sub, and everything's OK.

Well... the accompanist singers on each track, or the musicians on each
track, or the instruments on each track also have a MANY relationship, and
should be included in the table that holds the track info.

Sample CD table... (pertains to the CD as a whole)
CD Name, Title, Performer, Producer, etc.
Sample Track table... in your subform table... (pertains to the
individual songs)
TrackNo, TrackTitle, Singer, Instruments, Musicians, etc.

hth
Al Camp
 
Back
Top