I'm trying to set up a cross-platform script that will find and open a folder on the network. The network folders are grouped under primary folders named "10000s", "20000s" etc. The final folders are numbered corelating to the record number. For example: Server->20000s->29001. So far I've got it working on Windows, but I'm not making as good progress on the Mac. On Windows I have a script step using "Send Event" to Explorer to open document using the calculation:

"explorer serverfolder_afolder_b" & Floor (Database::RecNo /1000) & "s" & Database::RecNo

Most of the calc just determines which major folder it's in, then it has explorer look for the final folder that matches the record number.

How does one do this on the Mac using the Finder? I haven't had much luck yet with Send Event. Is this better accomplished using applescript?

Ah, I figured it out. No need to define the finder in the calc on the Mac, just tell the event that it's the Finder application (buried in the Library core.app folder). I also had the path structure wrong. It wanted server:folder_a:folder_b: . Now working great on both platforms.