Generate Custom Number and assign to another field on the form
Posted on 2014-01-06
I am generating a custom record number based on three fields:
The custom number is created using the following equation:
= [SO#] & Left([Type],1) & [WOID]
I first used this equation as the source for the WorkOrderNumber field and the custom number was not saved in the field in the table.
So I then created an unbound field to capture the custom number and then I set the WorkOrderNumber field equal to the unbound field.
Neither saves the the custom number and I would like to save this number since it should not change once assigned.