Hello! (tl;dr below)
I have an Signage Inventory base. One table is “Designs” with each record being one design with the proofs and text attached. Another table is “Main Building” where each record is a PHYSICAL sign stored in the main building with a “Design” field that links to the design table.
I’d like the primary key for the Location to be a concatenation of the “Name” field (primary key) from designs & dimensions & [#]; BUT i’d only like the number to increase when it needs a unique value. Right now I’m using autonum but that’s of course numbering by record.
tl;dr: Is there a way to change this:
[Design|Name] & “
_” & [Design|Dimensions] & “_” & [Autonum]
(which gets me this:)
So that it will give me this:
Thanks for any help!