Does any one know how to merge 2 primary keys into 1 (including all the child tables)?
The thing I'm looking for is like Quicken's ability to merge 2 accounts into 1 when they have the same name.

Obviously when I try to change the primary key field in a table, VFP won't allow it. If there were some way to build into the RI to change the child tables, then I could just delete the extra parent record, but I can't figure out how to do that either (and have it automatically updated as new child tables are created).

TIA