A
absh
Guest
I want to build a form with two variables which have a many to many relationship. I have created 3 tables:
1. Variable X Table
2. Variable Y Table
3. Join Table w/ Variable X, Y and KeyID
I'd like to have a main form for variable X and a subform for Variable Y.
I would probably eventually want a Main form for variable Y and a subform for Variable X.
The part I can't figure out is how to set up the forms such that I can use a combo box to change the X & Y variables.
I'm being a little vague because I may be going about this the wrong way. Can you help? I'll post more details if you want, too.
1. Variable X Table
2. Variable Y Table
3. Join Table w/ Variable X, Y and KeyID
I'd like to have a main form for variable X and a subform for Variable Y.
I would probably eventually want a Main form for variable Y and a subform for Variable X.
The part I can't figure out is how to set up the forms such that I can use a combo box to change the X & Y variables.
I'm being a little vague because I may be going about this the wrong way. Can you help? I'll post more details if you want, too.
