Filemaker Objects

Question

I'm trying to copy some field values to a duplicate database. One record at a time. This is used for history and so I can delete some records in the original database to keep it fast.

I don't want to manually save the values in a variable because there are hundreds of fields. So I want to go to the first field, save the field name and value and then go over to the other database and save the data. Then run a 'Go to Next Field' and loop through all the fields.

This works perfectly, but here is the problem: When a field is a calculation you cannot tab into it and therefore 'Go to Next Field' doesn't work. It skips it.

I though of doing a 'Go to Object' but then I need to name all the objects and I can't find a script to name objects.

Can anyone out there think of a solution?

Thanks!

Answer 1

This is one of those problems where I always found it easier to do an export/import.

Export all the data you want from the one database, and then import it into the other database. All you need to do is:

• Manually specify which fields you want to copy
• Map the data from the export to the right fields in the new database/table

You can even write a script to do these things for you.