ADO using an sql statement to join tables

[spnz]

Hi there

I am hoping someone can give me a few pointers on how to get started on what I am trying to achieve....

I have 2 tables that form a 1 - to - many relationship.

I have designed a form that I wish to show fields from both tables.

Using ADO I would like to be able to open the form and be able to see my desired fields in the same form.


Can anyone provide any ideas on where I can get started.


Thanks for your help!!

 

[spnz]

HI Pat
I was not using a bound form as I wasn't sure how to do it using more then 1 table..

How could I bound it using 2 different tables?? Do I create a query with the tables I want and then bound the form to that query?


Thanks for your tips