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
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
append: "IB-C" & [autonumField],
but yeah, why put the "IB-C"?
If the prefix is always IB-C, there's no point in even having it as part of the key.
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
So easy I'm embarrassed, Thank you
Any key that is set for NO DUPLICATES in a table is just that - it cannot be duplicated.But I need to append this table to another table for transactionsID to make sure I don't duplicate it.