I'm writing a job catalogue for a graphics workgroup. It's going to run on an Xserve and be accessed by three Macs.

For each of the job records, I'd like to create a folder link which will work by:

1. Click button

2. Switches to Finder, opens the relevant folder

I'm happy for users to link manually to the folder when they create the record (but it's an advantage for them to do this via the GUI rather than typing, or cutting and pasting, the path).

What's the best way to do what I want? Are container fields the best approach, or is there another way? Can I do it with built in FM functions, or do I need a plugin (such as the Troi file plugin)?

Please note, this solution can be Mac-only. But there will be Windows users accessing the database; it would be an advantage if the folder link worked for them but it's not essential.

Also note: I'm building this in FM7, but by the time it's running my workplace will have upgraded to FM8.

Update: I got the Troi file plugin. I recommend that anyone else who needs to do similar things does the same, it's very good and not expensive (can even use the £300 developer licence to deploy it for as many users as you like). There's a free trial if you're not sure.