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