I need to create a unique reference number in a separate field which, suprisingly I have called URN
I require it to be in the series 90,000
Is it possible to use the record number to create a URN in the URN field using the query feature? ie 90,000 + 1 (90001) for the first record, 90,000 + 2...