I’m trying to create an auto-increment field, but one that can be changed. I have a list of suppliers, and instead of sorting alphabetically, I have a field in the table called SupplierOrder. The query sorts by this field.
Lets say I have 10 suppliers. If I add a new supplier, I want the SupplierOrder field to be “11”, but I also want to be able to change the order that the suppliers appear in.
Is this possible?
