Answer the question
In order to leave comments, you need to log in
How to auto-number orders linked to specific stores?
When creating a new order, it is necessary that the numbering of those linked to stores (categories) takes place. Suppose, if from one store, then the numbering should be as follows: m1, m2, m3 ... etc.
With another, similarly, only the letter is different. I don't know how to implement it....
Answer the question
In order to leave comments, you need to log in
manually calculate the number. such logic.
create a maxnum table with fields idshop, num
increment num for the required idshop on each insert
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question