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.
The relationship between the old table and the new is a one-to one relationship.

As always, any help is greatly appreciated,

David92595

 

[dhookom]

Your form can be bound to a query or SQL statement that use more than one table. You can also use a subform.

Duane
Hook'D on Access
MS Access MVP

 

[David92595]

How do bound my form to more than one table using a SQL statement when I need to do an update?
Do you have any simple examples I can look at?

Thank you!
David92595

 

[dhookom]

I'm not sure I understand what makes this complex. What happens if you change the form's record source to something like:

SELECT A.*, B.* FROM [ExistingTable] A JOIN [NewTable] B on A.PrimaryKeyField = B.PrimaryKeyField;

If you can't figure this out, please provide more significant information about your tables and fields.

Duane
Hook'D on Access
MS Access MVP