Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012
    Posts
    56

    Unanswered: Form subform with linked tables

    Hello Evertone,
    I have a form and subform with two linked tables with a one to many relationship. I want to copy records from another table or could be query and insert them into my subform table this would then be linked to the main form maintaining the relationship of the two tables. I have tryed to use an array with getrows but have not had any success. Thanks in advance.

    Bob

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try using an INSERT INTO query


    however copying data from one table to another is usually a symptom of iffy design. the data should only be stored once within a schema
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2012
    Posts
    56

    Update

    Thanks I will try that.

    Bob

Posting Permissions

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