calc defined off previous record

[VICH]

i want to have calc feild that is a key number for plans in my office....and every time a new one is put in it is given a key number that is the most recent key number + 1...how would i use a calc feild to reference the previous recrod to calculate a number on the current one?

[Søren Dyhr]

Take a look what David Kaschel writes about ID'ing on page 6 of:

http://www.codemastersworkshop.com/Downloads/WhitePaperForFMPNovices.pdf

And while you're at it read it all, as soon as posible ...everyone benefits from thinking his proposals thru!

--sd