Hello,

I have Three tables something like the following

table_CD number (PK)
CD_ID number
Title text



table_CD_Song
CD_CDS_ID number (PK)
CS_CD_ID number
CS_Song_ID number



table_Song
Song_ID number (PK)
Title text
Duration text
Artist text


I would like to be able to generate a form that outputs the CD title followed by the

songs on the Cd all on the one page, something like the following:

CD number 1 - Song Title one, Song Title two, Song Title three
CD number 2 - Song Title one, Song Title two
CD number 1 - Song Title one, Song Title two, Song Title three, Song Title four

I can currently use a form with a subform to output

CD number 1
-Song Title one
-Song Title two
-Song Title three

Then you switch to CD record two and get
CD number 2
-Song Title one
-Song Title two

any suggestions would be appreciated

Chris

Do you want a form or a report? Usually you do this kind of listing in a report, not a form. The form would be way too long.

I would make a continuous form on the CD, then add a subform in design view with songs on the CD.

To speed development, I would use tbl instead of table. That is a lot of typing. Also, unless you are doing Oracle, you may want to use Pascal casing instead of underscores, like tblCD, CDID. And your junction table can still be tblCD_Song.

Okay, so I am OCD. It works in this business. :D


mmcdonal