Can I automate the process of defining fields?

[jeffff]

Is there a way to create a new table in a database by importing a (for example) tab-delimited file, and have it create the field names based on the 1st record in the file?

Alternately: I have not been able to figure out how to copy a table from one filemaker 7 database to another without redefining the table in the target database manually.

I just want a way to automate field definitions because I don't find Filemaker's define fields dialog to be very keyboard friendly.

Thank you very much for any help you can provide. This seems like a basic database function to me, and I don't see anyone asking about it in the forum, so I suspect I'm missing something rather straight-forward.

cheers!

Jeff

[cobra]

Hi Jeff,

The File > Open dialog will create a new table (in a new database) using values in a tab-delimited file.

For existing databases (as far as I can see) there is no way to copy tables or create a table based on a file to import.

I just transitioned a large project from FMP 6 to FMP 7. Having these facilities would have made life a great deal easier.

Cobra

[bruceR]

It can be done with applescript and GUI scripting using System Events.