Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

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:

(
& "-" &
[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.



  • It can be done. You will need a table of item types where the key field is the item type. Then a relationship to the items.

    Then a summary maximum of the increment counter portion of the SKU.
    Then look that up down to the items,
    Then make a snapshot of yhat lookup,
    Then add 1 to it for the next item.

    It�s a bunch of work to set up and awkward to get the numbering stared when you have existing data.

    You will have to decide if it�s really worth spending hours getting it built and the data loaded. You would need an SKU override field to load the initial data..