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

Subforms - 4

P: n/a
Hi,

I've just started to learn Access and I have a little problem with the
subforms.
I'm making a database to keep track of my collection of beercoasters.
The database is the following :

tbl_Brewery
-------------
BreweryId
Name
BrandId

tbl_Brand
----------
BrandId
Description
BreweryId

tbl_Series
----------
SeriesId
Description
BrandId

tbl_Coaster
------------
CoasterId
Description
SeriesId

So, as you can see each Coaster belongs to exactly 1 series, each series
belongs to 1 brand and each brand belongs to 1 brewery.
The relations are all made but the problem is that I want the information to
show on 1 form with 3 subforms.

I already used the wizard but it only goes to max. 3 subforms
When I choose a series, automatically I get the linked brand, and from the
brand I get the linked brewery.

But :
I want to be able to select the brewery and only choose (combobox) from the
brands that are linked.
Same for the brand, I only want to choose from the series that are linked

Can anyone give me a solution or should I keep studying till I find the
answer myself

Tia
Tora
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.