Hi,
Thank you for your advise. I am starting to develop the module of replication. However, I face some problems here.

My design:
1. I store all tablenames in a table named tbltables. It has a field that specific the "role" of the particular table in replication. It is either send to server, send to client or both.

2. Then, it also has some memo fields that will store the coding of each tables to execute some extra process before/after the replication done. For example, a after replication process for sales that will update member's points base on each member sales.

3. My program will SCAN thorugh those tables recorded in tbltables and verify it's role. Then, compare each records with it's backup table (which will be copy to another folder after replication). Any new/updated records will be insert to another table in a folder called ForwardFolder.

Hmm.. I think the design above should be fine.. (still under design and testing)... however, if I need to have filtering of the records before replication, how should I design it, expecially there are some master and child relatinship tables. For example, sales will have a child table called sdetails.

So, only records that belong to master sales table (which is valid for replication) should be copied. How to do this?

Do you think I should record the master table of each table (if any) in tbltables, then re-execute master table's filtering procedure again in order to get child records??

Do you have any suggestion?

Thank you in advance.
Please don't hestitate to ask if any unclear matter.