Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    Posts
    10

    Unanswered: Tale of 2 Tables...

    I have one database with 2 tables. I have a relationship between the tables that links the name fields in both tables. I have a form that adds new records to the first table; however, I can't seem to automatically add the corresponding new record to the 2nd table. All I need is to create a new record in the 2nd table with the name field filled in as the same name from the first table. I've tried an append query and I've tried to open a form based on the second table, automatically plug in the name, and close the form. I've had no luck with either of them. Please help...

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    Relationships really don't have anything to do with this.

    An append query should work.

  3. #3
    Join Date
    Oct 2001
    Posts
    10
    actually, I just created a query with all the fields from the first table and the field I wanted from the second table and based my form on the query instead of the table. I have the field from the second table invisible on the form and it automatically takes the name from the first table. Works fine and was real simple. thanks.

Posting Permissions

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