Mass update of data between tables

[Simon UK]

Hi,

I've created an offline 'cut-down' version of my db so users can wander around with their 'Netbooks' collecting data before coming back to the office or any wireless connection where they can synchronise with the server.

I've created this 'huge' script that steps through the various fields that have to be copied to the 'offline' db and I have used variables to store the data from the online db and then 'set field' to copy the data to the offline db.

Does anybody know of quicker way to do this? Perhaps have some kind of label to denote which fields require up date to the offline db and have a loop to work through them. I suppose I'd need some kind of translation table that showed which fields in the online db were supposed to update fields in the offline db.

I feel like i'm getting towards an answer as I type but any better suggestions would be appreciated.

As always a brilliant forum and your assistance over the last few months has taken me from absolutely filemaker newbie to almost releasing first commercial product.

Thanks again.

[James Marshall]

Hi Simon,

Have you tried doing a matching import?

James

www.soliantconsulting.com/apps/filemaker/

[Simon UK]

Matching Import ... sorry can you explain.

Did you mean to point me to your blog?

Regards