Results 1 to 5 of 5
  1. #1
    ijo68 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    37

    Append text to Sub Form remarks field using Append Query

    I have two related Tables .. (one to many relationship) .. table one has contact info, table 2 has remarks. I am trying to append a remark into table two using an append query. When I run the Append query it should put a remark into the Remarks table, using the related ID field. the problem is it does, but because the remarks table has multiple IDs (the many side of the relationship) for the same record it adds the remark multiple times ... and if there is no related ID (no previous remarks for that record) in the remarks table it does not append, in other words it doesn't create a new remark ID. any help will be appreciated. Thank You Kindly

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Maybe post your append query?
    using the related ID field
    Of what?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Should be as simple as the following (I made up table/field names)

    INSERT INTO Remarks (CustomerID, Remark) VALUES ( [Enter Customer ID], [Enter Customer Remark]);

    But a typical form and subform setup would avoid the need for this altogether.

    Does your remarks table have an Autonumber for a primary key?

  4. #4
    ijo68 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    37
    Yes it does,, I figured it out ,, I'll post a copy ... Thank you
    Click image for larger version. 

Name:	AppendQ.jpg 
Views:	8 
Size:	122.7 KB 
ID:	44099
    Attached Thumbnails Attached Thumbnails Append Q.png  

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I am not following your description of what you are trying to do.

    Can you tell us a little more about what relates Contacts and Remarks? Some example of a typical contact and a few remarks may be helpful.

    An observation is that your parameterized query is relying on the user to be consistent in spelling and grammar when entering information.

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

Similar Threads

  1. Replies: 4
    Last Post: 11-04-2019, 06:53 PM
  2. Replies: 19
    Last Post: 10-03-2017, 09:10 AM
  3. Access can't append all the records in the append query
    By fluffyvampirekitten in forum Access
    Replies: 2
    Last Post: 08-27-2015, 01:53 AM
  4. Replies: 7
    Last Post: 06-05-2015, 11:13 AM
  5. Replies: 7
    Last Post: 07-21-2011, 01:01 PM

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