Merging Child along with Parent records [message #8962] |
Tue, 07 October 2003 07:49 |
denise
Messages: 64 Registered: November 2000
|
Member |
|
|
We have two tables Prospect and Memo.
We have a Merge Procedure for duplicate records
that inserts the idnumber of merged prospects
into the memo column in the Memo Table and then
deletes the duplicate prospect.
When it is a first time merge there is no problem..
however once a memo child record has been created
and another attempt to merge that same prospect with another prospect occurs...we receive a parent-child
violation error.
question is:
how would we go about merging both child record(into Memo Table) and prospect(into Prospect Table) if
exists a parent-child relationship.
The child record would need to take on the idnumber
of the newly merged prospect idnumber.
thanks
|
|
|
|