I am about to update a system for a Car sales showroom (originally developed in FMP2!).

I would like the new system to be able to find and automatically insert into various layouts a picture of a vehicle sourced from electronic camera and stored in common folder with filename eg "W234RVT.JPG" (ie vehicle registration number.JPG). My problem is how to get FMP5 to find the picture for an individual vehicle via a database field which already contains the unique registration number, except for the "jpg" bit. I hope to be able to do this automatically via some neat "concatenation" type calculation or similar to drop/paste the filename into a container field. Can anyone suggest a solution.

I understand that this is very easy to do explicitly/manually but I wish to protect my users from this chore. The application will eventually serve the data via the web.

My unavoidable platform is Windows....

------------------

Reg Aldridge

Elistix

"Joined up Thinking" for E-Business

I dunno any way to insert automatically pictures and it puzzles me some time.

However, there is not a problem to serve web with pictures

1. Directly from FM

2. FM has only the names of pictures and pictures are sitting in site folder and the reference is calculated via WebCompanion.

Anatoli

In the CDML page (If possible don't have the images on the FMP machine)

<IMG SRC="path/[FMP-Field: vin].JPG">