>I have a small application that I use to keep track of properties, and a ticker file. There are only three tables: next unique key, property, and ticklers. The property and tickler table has a unique key (generated by adding 1 to the next unique key), date record modified and date record added.
>
>I have now taken on a partner and we both work on our on PCs, at our own houses. Need a way to sync our data together. So thinking of how to write a merge or sync program.
>
>Thought that I could start my partner off with a next unique key of 100,000 so that my added records and her added records never get the same key. Of course procedurally we can not work off the same list so that we do not seperately add the same property.
>
>But, I will work on her added properties and she will work on mine. So I need to sync the fields on the property records. Also, the tickler records are added with the unique-key+sequence. It is not so important that the exact sequence it maintained, but guess I can use the date added to resequence new records.
>
>Just looking for ideas on how to sync or merge two copies of tables into one. We will merge probably once a week so that we can have accurate reports.
>
>Brenda
I think one option would be for one of you, or both, can work with offline views.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)