Add new items

G

Gargamil

I have a table which contains all a local snapshot of the WorkOrders for a
given section of the company going back about 15 years. If I take the
snapshot of it today there may be some currently opened Work Orders that are
modified on the server that will not be returned to the local copy since the
key fields are the same only the detail within the table is changed.
There is a last modified field which can be used to determine which records
have been changed since the last snapshot. How do I update the modified
records onto the local copy, given that the original local records have the
same key fields?

g
 
Top