Results 1 to 4 of 4
  1. #1
    DenisM is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Location
    Sleaford Lincs
    Posts
    29

    How to display 2 attachments in 1 record instead of 2 records

    Hello,
    I hope somebody can help. I have a Countries file that has a flag field which is an attachment. If I append two flags in this field and run a query I get 2 records.
    What I want to do is create a form using this query as the source and display 1 or 2 flags if they exist for each country, not 2 screens if there are 2 flags. Hope that made sense.
    Please see attached.
    Thank you for any help.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    it looks like you created 2 records. You want to keep attaching flags to the ATTACHEMENT field on 1 record.
    showing is a different matter. Attachments are too difficult to work with, so your example of having 2 sub records is better.
    the sub form can show 2 flags as 2 records. The easiest way, and the user can see all the various flags 1 country has.

  3. #3
    DenisM is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Location
    Sleaford Lincs
    Posts
    29
    Thank you for your response. You confirmed my suspicions. Sorry for not replying sooner.

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I'm pretty sure attachment fields work in much the same way as multi select fields - access builds a hidden table behind the scenes

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

Similar Threads

  1. Replies: 4
    Last Post: 06-19-2019, 06:29 AM
  2. Replies: 5
    Last Post: 09-29-2015, 11:08 AM
  3. Attachments to display their filenames
    By Modify_inc in forum Access
    Replies: 9
    Last Post: 01-09-2013, 01:58 PM
  4. Display every attachments in report?
    By mitchel in forum Reports
    Replies: 7
    Last Post: 02-11-2012, 07:53 PM
  5. Append records with attachments
    By Dawie Theron in forum Queries
    Replies: 1
    Last Post: 01-22-2010, 06:19 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