In File Maker Pro 7 (OS X) I would like that on creation of a new record a new folder will be created in a specified root directory. The folder would have to have the Student name of the record (it is a school db of students)Then inside this folder I would put scanned images of certificates, comendations,etc.

The purpose of this is to be able to click on a button within a layout/table (Table of student info) called 'certificates' for example and it will bring up the scanned image or images that the folder contains.

I hope you get what I am aiming to do. Is there a better way to do it?

Any help would help, thanks.

I am working on an A-level project so I might be asking some more questions in the furture

PS: Sorry I didnt know were to post this. (And I dont know which version of OS X my school is running)

You might want to post this in the Applescript forum, since that might be the best way to accomplish this... there are people who browse that forum who might be able to help.

Hi Reed,

I believe you meant that he should request to have his post moved, not to [color:red]Double Post the Topic?

So, I moved this to the AppleScript Forum as you suggested. We'll see what Pros can come up with.

Lee

right, that's what I meant ???

With AppleScript it could be something like this. This will create a folder "Students" on the desktop, then create a folder inside it for every new student created in the database (when you run the New script).

StudentFoldersAS.zip

Thanks alot I will try it out tomorow. (I am at home now on my pc) Will post here if I have any problems.

BUMP^^

The folder script is working perfectly (thanks to Fenton) but I have more problems:

I am having trouble getting a find script to work correctly. I copied it from a pre-made database that came with filemaker pro 7, its called 'Student Record' and is in the 'Education' section of these examples.

I have a attached a copy of my database*, could someone please have a quick look at it and point me in the right dirrection?

I nead it to be able to search by every field in the student records layout, then for example all students who got grade 3 in year 7 in the transcript layout, all students who havent paid in the fees layout. I hope you can understand what I mean once you see the database.

And also comment on it in general (feedback)?

As I said in the first post this is for an A-level project which is due in soon

Thanks for any input.

*if it doesnt work here is a link to an uncompressed version

Database.zip

Edited April 3, 200619 yr by Guest