By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

Sub-groups in a field

P: n/a
I'm new to databases and I'm trying to learn by making a simple
database to keep track of my CD collection. I have a table for Bands
and a table for Albums. In a Favorites table, I would like to select
from a list of bands (this is working fine) and then see a list of
albums by the selected bands. My problem is that I don't know how to
restrict this list to display only albums by the selected band. Can
anyone help me do this?

Thanks.

Jan 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Trent wrote:
I'm new to databases and I'm trying to learn by making a simple
database to keep track of my CD collection. I have a table for Bands
and a table for Albums. In a Favorites table, I would like to select
from a list of bands (this is working fine) and then see a list of
albums by the selected bands. My problem is that I don't know how to
restrict this list to display only albums by the selected band. Can
anyone help me do this?

Thanks.

I'll assume you have a key like BandID, autonumber, in the Bands table.
You also have BandID to link to in the Albums table.

Create a form with the band data.

Create a form with the album data.

Open BandForm in design mode. Find the Subform tool in the toolbox.
Drop that tool onto the BandForm, select AlbumForm, and set the link to
BandID.

Jan 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.