Hi All,

I have created a DB in FM11Adv that assigns a new invoice number each time a new record is created. Currently when I set up the DB I go to the DB section and assign the starting number with increments of 1.

I would like to be able to put a field on my preferences page that you can input the starting invoice number is 13-0005 for example and then as a new record was created, it would advance it by 1 and place it in the invoice field.

 

It's working fine the first way, but it would be nice to lock down the access to the DB on set this way up and allow the user to set it.

 

Any ideas would be greatly appreciated.

 

MG

first record created - set invoice number by data entry to whatever is wanted

from then on - script to create new records:

show all records

sort records by invoice number

go to last record

set variable - $number

create new record

set field (invoice number); $number +1