Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 22nd, 2005, 01:26 AM
Authorized User
Join Date: Nov 2003
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Forms


I have Three tables something like the following

table_CD number (PK)
CD_ID number
Title text

CD_CDS_ID number (PK)
CS_CD_ID number
CS_Song_ID number

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


Old March 22nd, 2005, 08:32 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forms and Sub forms Mink Access 1 December 1st, 2004 08:38 AM
Opening forms from other forms Paulsh Access VBA 1 September 30th, 2004 06:54 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.