>Federico,
>note that in VFP a deleted record is not removed from the tabel (until you
>pack or do some similar action)
>thus the deleted keys still exists and can potentially be restored
>
>you can either use surrogate keys , which is a name to keys that bare no
>relation to the data ( most recomended IMHO)
>another option is to recycle used keys - i.e. recall the deleted record and
>overwrite the data
>yet another option is to add a filter on the primary key - but IMHO this is
>not a very good idea (kinda beats the whole idea primary keys if you ask me)
>
>Arnon
>
Is there any impact of using surrogate keys on
1) Defining Relationships and
2) VFP's default Referential Integrity ( not xcase )
TIA
Prakash R Bhat