I got I think a real good-one.

We currently sync. our app from one-site to another site. Everything works great, but we have an issue with notes. Our notes are user date and time stamped. each time the user enters in a note it is stamped:
***Username***DTOC(date()) time()

When we sync the incoming files update the recieving record with changes, however, the notes are overwritten with the incoming datas notes. We need to merge these notes based upon the date and time. Newest always ontop. The data being transfered can be a single record upto whatever number of records, each with separate notes.

Ideas please.

Thanks

Larry