>>I have a table with clients and all cliens has his number.
>>
>> # 001 - Marck
>> # 002 - Mary
>> # 003 - Carl
>>
>>
>> Which is more programatically correct:
>>
>> To create a field that will contain the client number
>> or use the own table recno () ?
>
>To create a field that will contain the number.
>If you use recno() and one day a record is deleted. Subsequent additions to table would be duplicating previous ids.
>Cetin

Before someone misunderstands me :
You cannot duplicate a recno() but any reference to that in another table would be pointing to incorrect number. ie :

Records # Names
1         Name1
2         Name2
3         Name3
4         Name4
5         Name5

* 2 and 4 is deleted (packed) 3 new recs added
1         Name1
3         Name3
5         Name5
4         Name6
5         Name7
6         Name8

Cetin