>>>>Hi All,
>>>>
>>>>My problem is, when I add a new person to my Parent table I also need to add theit Social Security number to about 8 other tables (SSAN is a candidate key). I don't know how to go about creating a custom procedure and modify my referential integrity. Is there anybody out there who have these same requirements and how did you go about accomplishing the task. Using VFP 5.0.
>>>>
>>>>Thanks in advance
>>>>
>>>>Jon
>>>
>>>YIKES!!!!!
>>>
>>>Are you using SSN as a key????? YIKES!!!! SSN is NOT unique. There are duplicates. I went to college with two people that had the same SSN. Talk about a nightmare.
>>>
>>They should be unique identifiers for U.S. citizens, but due to fraud/error it's possible to have trouble, as you say...
>
>It's not just fraud. Error is the main problem. The government has issued duplicate SSNs.
>
>Craig

OK OK

I still need SSAN. Did I see somewhere in my 5.0 documentation about creating unique keys that I can use? Also, I try to recycle my records so I don't have to do a pack so often. Do you guys have any suggestions/solutions?

Jon