DDE Script for Importing PDF's

[jcohen]

I am not sure how to create a script to import different PDF files. Here is the scenario:

I have a FM file with 1000 records. Each record has a unique ID. Each record also has a container field labeled PDF that is set for PDF files. Existing on a network drive, there are 1000 different PDF files that each have a unique name that corresponds to the unique ID. I.E., record 1 has an ID of 0001; this would mean that there is a PDF file named 0001.PDF stored on a network drive. I am using FM 5 on Win 98.

I need to create a script to find the corresponding PDF file and insert it into the records container field.

My thought would be create a DDE script to copy the record ID and paste it into the Win 98 finder and add the ".PDF" suffix. This would find the appropriate PDF file. From there, insert the PDF file into the container field.

I am not very familiar with DDE script steps, but have a very advanced understanding of scripting.

Any help would be GREATLY appreciated.