Using AppleScript to build a database from scratch

[Andy James]

Forgive me if this has been talked about before.

When I'm creating a new database I often face a lot of work just adding tables and fields by hand. I often find that each table has 2-3 of the same fields (title, primary key), same naming convention, same options (especially auto-entry of serial numbers) ... you get the picture. A lot of tedious work that seems ripe for automation.

I'd like to be able to make a list of table names and have AppleScript build the database off that list, and automatically stock each table with fields that follow the naming convention and are set to the correct options.

Has anyone seen a solution like this?

[Søren Dyhr]

It wont take you long when you inspect the directory in you favorite applescript-editor haul in on behalf of filemaker to recognize that creation of fields or tables isn't an option.

But you can instead use this:

http://www.cnsplug-ins.com/products.htm?product=mmquery

...and let a native scriptmaker build the required basic's.

--sd

[Fenton]

Or upgrade to FileMaker Pro Advanced, which can copy/paste fields or entire tables. Create a "template" file which has the required fields, then just duplicate or copy/paste as needed.