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.

I sent you a sample many-to-many db.

For Pat Hartman, can you send me many to many db sample thans
Dennis