>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
You can have a function that gets the next number from a sequence table, and increments it in the sequence table.
If you are interested, I can search my version of this function, and post it.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)