Results 1 to 6 of 6
  1. #1
    dave_co is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Posts
    3

    Custom Primary Key Append to Another Table

    I have a custom Primary Key auto number with a format "IB-C"0000000 how ever when I append to another table non primary key field it only appends the number how can I get the whole format?



    Thank you in advance

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    append: "IB-C" & [autonumField],
    but yeah, why put the "IB-C"?

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    If the prefix is always IB-C, there's no point in even having it as part of the key.

  4. #4
    dave_co is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Posts
    3
    Hi Davegri,

    But I need to append this table to another table for transactionsID to make sure I don't duplicate it. Sort of a copy from a sub table of transaction to a master table as I have more than one source of transactions with different fields.
    Thanks for the response

  5. #5
    dave_co is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Posts
    3
    So easy I'm embarrassed, Thank you

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    But I need to append this table to another table for transactionsID to make sure I don't duplicate it.
    Any key that is set for NO DUPLICATES in a table is just that - it cannot be duplicated.

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

Similar Threads

  1. Import Excel Access - Primary Key - Append table
    By mduplantis in forum Access
    Replies: 7
    Last Post: 10-03-2016, 10:39 AM
  2. Append primary key record
    By WSelen1986 in forum Access
    Replies: 4
    Last Post: 12-10-2014, 12:02 PM
  3. Replies: 5
    Last Post: 07-06-2014, 10:18 AM
  4. Sharepoint Custom Primary Key?
    By Steven.Allman in forum SharePoint
    Replies: 1
    Last Post: 06-20-2014, 11:06 AM
  5. subform primary key null value want custom msg
    By raton in forum Programming
    Replies: 1
    Last Post: 03-24-2012, 11:35 AM

Tags for this Thread

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