I have a table named "Parts" (parent) and another named "Serialized Parts" (child).
I need to generate serial numbers on the child table, starting at 0001 (with leading zeros), for each part.
This is how I have it configured currently:
Summary field "# of Serialized Parts" and a lookup field for the same thing on the child table
Snapshot field referencing the lookup field, and a formula text field with this:
Right("0000" & ToText([Snapshot for S/N Formula]), 4)
Which gives me a 4 digit number, starting at 0001 for each Part.
Here are my questions regarding this:
1- I want a Numeric field for the S/N, not text, how would I do that?
2- Is this a bullet-proof method to accomplish what I want with no risk of having duplicate serial number or any other issues in the future? This will be our primary and only solution for tracking serial numbers (aside from backing up QBase). It has to work perfectly.