Recent content by jimsterman82

Yes it is a multi-user database.

I didn't realize from the earlier messages but we have some older numbers with -01 and -02 on them (A number data type wont allow the -01, -02). Am I able to auto increment a text field if it has only numbers including the -01? Ex. SM-004112-01 This happens rarely, but it does happen.

Thanks again, Unfortunately I am unable to use the autonumber field. Some of the older numbers were duplicated and some had -1, -2, etc added to them. If I add the SM- as formatting or as an alias is it still searchable as the whole number (ex. SM-004112)? Or would I have to search for only...

Thank you for the reply. The numbering system is generic. So all numbers follow the same format of SM-000000. So: SM-004112, SM-004113, SM-004114, etc...

Hello, I am looking to auto-increment a part number every time the New Part number form is opened. I am trying to use the default value of the Part Number field in my form for this. Will an input mask interfere with this? We are moving data over from an old spreadsheet and so many part numbers...