I have a numeric field I created in my clients.dbf

Numbers are put automatically at every new register by:


use clientes
appe blank
store ID to a
a = a + 1
replace ID with a

As ID is not ready-only on the form
because client asked so, how can
I do to prevent duplicate IDs.

Ps. A use free tables