ArchiveUser
7 years agoQrew Captain
SKU number generator
Hi all,
Is there any way I auto-generate a sequential number and include it to the SKU number without depending on the record ID? (last 3 digits)
I'm still figuring things out and these are my following results as it is still dependant on the RecordID:
8652674-210-001
8557-233-002
CC-220-003
This is my code:
(
Is there any way I auto-generate a sequential number and include it to the SKU number without depending on the record ID? (last 3 digits)
I'm still figuring things out and these are my following results as it is still dependant on the RecordID:
8652674-210-001
8557-233-002
CC-220-003
This is my code:
(
& "-" &
[Equipment Type] & "-"
& Right("000" & ToText([Record ID#]),3))
I want to be able to create the SKU number based on the sequential # of that specific number type. Hence, the ideal results would be for the number to automatically generated, given the condition that it is the same type of item.
8652674-210-001, 8652674-210-002, 8652674-210-003....
8557-233-001, 8557-233-002, 8557-233-003...
Any help or idea to implement this would be greatly appreciated!
Thank you.