Hi there,

I work for a recruitment company and we have a database of around 3000 candidates. Currently, when a candidate is registered on to the database, a registration number is generated. This corresponds to a MS word file with CV documents named the same.

My question is; Is it possible to have a button on the database (each individual record) which, when pressed would open up a word document? If so, how could it be possible for this button to open up the corresponding CV?

Any help would really be appreciated.

Thanks in advance.

Mark

When you name the word doc what is your naming convention and how does this tie in with your reg# from fm? What is a cv document..

We do something very similar here at our company but I need to know the above info to help. We have become a 90% paperless office.

Stu

I'll put any naming convention on the Word document, or better yet, Adobe Acrobat file that will allow you to open the file from within FM.

mb

The reg number in our candidate database is for example: 00564 and would represent the 564th record on our database. The person's CV / resume would be saved in a file on microsoft word and would be 00564.doc.

How is it possible to click a button on the candidate record and get it to fire up the corresponding word doc?

Thanks for any help in advance.

Use the open url script step

OpenURL("c:path_to_item"&record number&".doc")

the record number is a field with the registration number

the path to the item is where on the hard drive the information is stored.

Stu

Hello 'mlennox',

I recently 'posted' a reply to another 'post' about how to 'open' MS Word documents from within FileMaker. In my 'reply post', I discuss how to store the MS Word files; how to 'reference' the MS Word files within FileMaker; and how to 'get' FileMaker to 'open' these MS Word files. Although my discussion relates to the legal industry, I think that it will have some ideas that could benefit you.

You can find my 'reply post' at the bottom of:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB16&Number=41309

Good Luck!

Bob Kundinger

by the way bob.... The info you had posted was a great help to us.. Thanks for all your detailed input... it was put to good use. Sorry for the delay

Stuj