script problem for you FM geniuses

[nateco]

Using OSX with FM 5.5's container field, I need to do the following. I have two files, one is "orders", and the other is "products". I have all the products that I sell listed in "products" and would like to place a product brochure (pdf file) in the container field. Some brochures are a single page, most are two or more pages. I would use this mostly as a pointer to the actual file located somewhere else. I use the "orders" file to generate a proposal and then follow the project thru to completetion. Most proposals include several products. I do a presentation via my powerbook and video projector, and then burn a cdrom with a hard copy of the proposal to leave with the client. The cdrom contains only pdf files.

So what I need is a script that will use the "orders" file with a list of products obtained via look-up from the products file to find the pdf files and put them in a folder for burning to cd.

I hope this is clear.

Nate