Hi,
I am writing a program that replicate changed data of branches and sent it to head office for batch processing and etc. After that, the updated data have to send back to branches.
I am using comparing working table data with backup table data to obtain the changed record and write it to forward table.
I have problem that:

1. My application allow user to reuse the code for example, customer code. We are using delete and insert method in this situation. Therefore, the "same record" may appear more than one (just one is not deleted, the other are deleted). Once i try to compare them with backup table data, i always get the first matched record (BTW, I SET DELETED OFF in order to get deleted record also). To solve it, other delvepers recommend me to have "myprimary key and NOT DELETED()" in my search condition when locate for the record in backup table (Thank you for your suggestion!!). However, it will get all "changes transaction" of each records. For example, AW01 deleted, AW01 deleted, AW01 undeleted record. How to solve this problem? If I try to locate for myprimary key when update the "changes" to forward table, will it work? This will get the final result of each changed record.

2. Should I place all the replicated data of branches in the working database located in head office or seperate these with head office's working database?

Thank you .
Pls don't hestitate to ask if your are not clear about my problem