Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014

    Unanswered: Auto Normalizing a Table


    I have two tables, one for questions, the other (a child) for responses. They were working fine until I combined the question table with another table, which then changed the ID so that the answers no longer correspond. How do I get the child table to to automatically update the foreign key numbers? There is no text to compare such as "A = B." THe only thing to compare are the Old ID/FK numbers. Thanks for any help.

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 23
    You need a subForm.
    Use the form wizard, to build a master form to show 1 master record,
    And a sub form to show the many children.
    The sub form will link on the key field and automatically add the FK to the child table.

Posting Permissions

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