Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Junction tables and subforms confusion

Status
Not open for further replies.

shellig

Technical User
Apr 19, 2002
34
US
This has probably already been asked many different ways...but I am not sure so:
I have the following tables:
tblTask
tblOwner
tblCat
tblSubCat
with junction tables
jnctTaskCat
jnctTaskOwner
jnctCatSubCat - this one is iffy whether we need to use the same subcategory for different categories...

OK...I set up a form for the tblTask with a subform for using JnctTaskCat.
I want another subform for the subcategory...but I do not know how to do it so only the subform categories available for the chosen category show up. I have tried several ways with no luck. Perhaps it is the table I chose or I need another table? Is it the relationship that I need to define that is wrong?
This is getting confusing for a periodic Access user!
Thanks for any suggestions you can give me.
 
Have a look at the Northwind sample database Customer Orders form. Does it do what you want?
 
Those tables are one to many and these are many to many...although the subcategory does not need to be many to many, can be many to one category.
I will look more carefully but there must need to be some kind of junction table to store the subcategory value for each category for each task...confusing!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top