>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

Sorry, what is IMHO? And why is adding a filter not a good idea? Anyway, most people don't regard deleted records as 'existing' records. Would there be any problem for the VFP standard referential integrity functions to work with the filter? Would it be necessary to create surrogated key for all tables?


Tai SC