Results 1 to 2 of 2
  1. #1
    mjj4golf is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Location
    Raleigh North Carolina
    Posts
    9

    Adding Record to a multi tablle query.``


    I am trying to get a record into a form and the form is based on the query using two tables. When I tried to add a record I get a message saying that the join type is missing in the second table. My question is this: is there a way to add a record to a query using two tables? I am assuming the join type they are referring to would be the fields that relate the two table - in this case it would be the ID fields. So it seems like the problem would be to get the ID in the first table into the ID field in the second table. How can I do this or is it even possible?
    Mike

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    maybe. Sometimes depending on the links you CANT edit the query.
    If you cant , the you may try using a parent child form and edit the child. It works like a 2 table query.
    if you still cant, use a single table and use combos to fill in items from the other query.
    But the parent/child should method should work.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-18-2013, 02:55 AM
  2. Replies: 3
    Last Post: 02-06-2013, 07:23 PM
  3. Replies: 4
    Last Post: 08-14-2012, 07:14 AM
  4. Replies: 14
    Last Post: 05-25-2012, 02:40 AM
  5. Adding table to Query removes every 4th record
    By CoachBarker in forum Queries
    Replies: 1
    Last Post: 10-13-2010, 07:23 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