Results 1 to 2 of 2
  1. #1
    David92595 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    22

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

    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

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    As asked before, where this was posted, is the Relationship between the Old Table/New Table a One-to-One or a One-to-Many Relationship?

    The former is usually handled by simply adding the new Fields to the original Table.

    The latter is normally handled with a Main Form tied to the Table on the One-side of the Relationship, and the Subform tied to the Table on the Many-side of the Relationship.

    Trying to base a single Form, without using this scenario, on multiple Tables requires a Query, and a Multi-Table Query is often times Read-Only.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How I can connect access table in browser
    By learning_graccess in forum Programming
    Replies: 1
    Last Post: 04-04-2012, 04:40 PM
  2. CALENDAR on form wont connect to TABLE
    By taimysho0 in forum Programming
    Replies: 6
    Last Post: 01-13-2012, 10:23 PM
  3. Replies: 0
    Last Post: 03-28-2011, 11:05 AM
  4. Connect Foxpro table in access
    By genny in forum Import/Export Data
    Replies: 6
    Last Post: 11-08-2010, 02:31 AM
  5. Replies: 5
    Last Post: 03-29-2009, 07:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums