I am trying to assign an order number that is generated when a button is clicked and performs an event so that the order number = previous order number + 1.
I don't want to use auto number because when entries get deleted the auto number counts from where it left off. Does anyone know how I can get the expression previous order number?