Results 1 to 2 of 2

Thread: access beginner

  1. #1
    Join Date
    May 2004

    Unanswered: access beginner

    I created the attached db
    I need to automatically update the details table from the main table...
    I know this is extremely basic but Im using an ado connection form vb
    and am having problems synchronizing the table with 2 seperate ado connections
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2002
    Sounds like you need to create a table relationship between the two tables first. With this in place you won't need to syncronize with code. I.E. when you add a detail record in a subform bound to a detail table embedded in a main form bound to a header table the id's from the header record will automatically populate down to the detail record.

    The relationship screen can be accessed from the database window via a button on the toolbar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts