>I've been working w/record oriented language for
>many years, and VFP for a few weeks of study,
>following manuals, books, etc.
>My first effort at building a small parent/child
>app, just to do something besides follow the stuff
>in the books, Mastering VFP,... are stopped at the
>point of creating an id number for each file.
>
>I build a small table, with two fields:
> cDescrip, 10 - holds an identifier for the
>specific table to be updated.
> cNextId, 6.0 - hold the next number to be used.
>
>My thought was to place a function in the INSERT
>table rule to open the "NEXTNUM" file, get the
>next number, increment the next number in NEXTNUM,
>then return the retrieved value to the record
>being created.
>It looked like this:
>------------------------------------------
> FUNCTION udfNextId
> *
> * Uses the existing next number for the
>field identified by
> * cIdDesc as the ID number for a new record.
> * Then increments the existing number, and