Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
David92595
Starting Member
8 Posts |
 Posted - 2012-08-22 : 19:38:45
|
| 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. In the past I have used forms and sub forms, but we have since moved to an SQL backend and I know more complicated items such as this can be done, I just don’t know how.As always, any help is greatly appreciated, David92595 |
|
|
|
|
|
Create A Form That Is Joined To More Than One Tbl