Good morning Zaheed,

If you are lucky enough to be using VFP8.0 there is a new feature which automates this task. It is a Data type with associated field properties in the DBC.

Glenn


>Hi All,
>
>I need to auto reference the next reference from the table. So that when I click on new, the textfield with the reference control source automatically brings up the next ref. IE last ref + 1.
>
>Thanks
>Zaheed