How To Connect More Than One Table To A Form, Access 2007

[David92595]

Hello,

Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end.

I need to find a way of opening up a form that is joined to more than one table in the backend. The users have to be able to enter information and update the corresponding tables with the new data in the form (Not a view only form).
For the more literal types, I need to connect our main table with a new table I just created. Our main table holds all of our ID #’s and other fields we need to display on the page, but we also need it to hold new fields for data entry to our new table as well.

As always, any help is greatly appreciated,

David92595

 

[SkipVought]

hi,

You might get better results in forum702.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[David92595]

Thanks, I'm still new to this site...