David92595
IS-IT--Management
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
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