Creating Many-to-one Form

[prao]

Hi all

Guys, you heard about ONE-TO-MANY form, I need to create a MANY-TO-ONE form. I need to have a tabular form (I mean Continous Form) on the top and Free form at the bottom. As the user scrolls the Tabular form (I mean Continous Form), the data in Free form must change. This I want to be in one form.

I want to use Subform and do this, how can I achieve the result.

I think I am clear with my question.

Thanks

 

[RichMorrison]

From your description, this sounds like a One-to-One relationship. You have a continuous form that shows "Many" somethings. But each something connects to One bunch of data in the "Free" form.

Yes, you can do this with a subform.

RichM

 

[prao]

Hi Rich

Thanks for the reply. Yes, as you said, it is One-to-One relationship. Can u tell me how to do this. I created a Continous form, inside that I attached the subform, which is the Free form.

But when I run the form, I only see the Continous form and not the subform. Moreover, the Continous form was big and was showing around 15 rows and below that I never say any free form.

Correct me if I did anything wrong and help me in achieving what I want.

Thanks once again.

 

[RichMorrison]

The "main" form in a form to subform relationship must be a single form, not continuous.

See Access Help for advice on creating and connecting a subform to a main form.

RichM