>I have created a large .dbc database and am trying to add a numeric field to 1 table and have this field automatically create a "Transaction Number" and each time a record is added that the table auto creates the next logical "Transaction Number". Basically like an invoice number but not for an invoice.
>
>
>Thanks for your help in advance
>
>Fred Watt

Update to VFP9, and use the AutoIncrement numeric field. Only available in VFP8 and VFP9.