Applescript to create folders below installation

[T-Square]

I have a solution that needs to have two sub-folders for long-term running. I have created an opening script that checks whether the solution has been installed, and if not, creates the folders for me. In Windows, I have a simple batch file that runs from a Send Message script command. I assume that I should use Applescipt on the Mac, but not being a Mac person, I have not been able to figure out a couple of (admittedly basic!) things:

1) I want Applescript to create the folders under the main database folder, which could be anywhere. Every example of Finder scripts specify the exact location of a newly-created folder. I do not know how to instruct Applescript to do this.

2) Once I have an Applescript, I can only seem to instruct FM to call up Script Editor--not actually run the script. The Script step looks like:

Send Apple Event["init","Script Editor", "misc", "dosc"]

I am sure that these problems are easy to fix, but do not know what to change.

Thanks,

David

[keshalyi]

Well...

let's see. What you need to do is provide the applescript with the path to your database. This is not too hard - what you can do is set a calc field in the DB to Status(CurrentFilePath), and then parse out the file name using a substitute command with Status(CurrentFileName). This will give you the path to the root of your install. Right?

[T-Square]

I'm going to guess that the Status(CurrentFilePath) is an addition to FM after 4.0, because it doesn't appear in my 4.0. That command would really help this process!