Incrémentation on différents table
hello, I use several tables and I would increment a variable with each new record regardless of the table. Then be able to put this number on the form created. I hope I have been clear in my explanations. Thanks for your help
2 replies
-
I assume you will keep the "increment value" somewhere globally accessible? As in it's own table? Assuming YES.. then create a global function that manages the "increment table".. and put call to that global function to return the next value in each tables "Trigger on create".
If it is going to be a Ninox Cloud / Multi User application, you may want to be careful of race condition.
-
thank you for your reply. if I understand correctly I have to create the table which increments a variable as soon as one makes a modification whatever the table.
Content aside
- 4 yrs agoLast active
- 2Replies
- 1109Views