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.
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.