I've created a FileMaker Pro 12 database with 15 tables, which will be used to create 20 runtime solutions.
I've writing a FM script to merge (i.e. import) the contents of the runtime solutions into a single database.
Two big problems, which seem ridiculous to me, so I must be missing something (I hope):
1) There doesn't seem to be any way to pre-select the source table automatically i.e. To say "match the fields in the source and destination tables named Staff" (I can only specify the destination table), which makes it impossible to do this without bringing up the import dialog box (15 * 20 times each time a merge is done).
2) Even when I do this manually with the import dialog box and have "matching names" selected, not all fields are being matched correctly.