New to FMP7, I have searched the Forums for an answer but I must not be using the correct terms.

I am building a db that will track mentors for a community program. Some of the mentors have provided me with their Profile in MS Word. I plan on storing a Link to the doc file in a container field.

How do I display one icon if a profile document exists for the mentor and a different icon if the document doesn't exist?

Additional if the file doesn't exist how do I script an object insert so that all the user will have to do is navigate to the file location?

although i haven't tried implementing this myself. i have thought of it before... what i had in mind was to use:

1. a container field for ur user to insert files

2. a calculation field that returns "container" type next to the first container that will be used to display the icon

the calculation field uses IsEmpty function to see if the first container is empty or not, coupled by Case function.

... it would look something like... "Case (IsEmpty (1st container); "image:Empty.jpg"; "image:Full.jpg")"

however, i am not completely *certain* if that's how filepath is supposed to look like...~ search the forum i saw some before