How can I increment a number field on a table every time I create a new record? Better describing, how can I make Ninox look up the value of a field on a previous record and adjust it for the new record?
I have used max(Field)+1 but it seems not to work.
This is just one example of many on the forum.
Thank you, it worked perfectly.