>In the field validation of the table the default value function is the following:
>
>
>
>ALLTRIM(STR(RECCOUNT()))
reccount()? And what happens when you PACK to get rid of deleted records? You will have duplicate primary keys.
You
might lock the table header, go to the last record, get its primary key, and increment it. But I believe it is safer to keep the sequence number in a separate table, as outlined in my previous message.
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)