>>>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer