BruceJackson

Seems to me it would be useful make the field into a button that opens up a table in a new window instead of opening a pop-up value list. The table layout can have whatever columns you want, along with a button that appears next to each record. On pressing the button to select that record, it places the ID# into the original field. Of course, I you knew my level of knowledge, you might suggest I read more instead of writing.

I think I figured it out myself. I already had the filepath coming into a text field. So I set up a new text field with a calculation in it. It uses the substitute function to change the filepath text from absolute to relative by dropping off the "file://C:/etc" and changing to "image:" When importing records (photos), I don't delegate the source image to a target container field. Instead I changed the image container field to look at the text field for its reference by including a calculation option. Any comments from someone who knows what they're doing would be appreciated. I'm bumbling around in the dark here. Only been doing this for 2-3 weeks.

When importing photos, I choose link but the paths are coded as absolute. If I burn the fp7 database with it's linked photos to a CD, the images aren't found because it's still looking for my computer's partition/folder structure. I want to make it default to using relative paths when importing images or files into a container field. Any suggestions on where to set this?

This may be basic, but I can't figure it out. The browser/layout page size defaults to 21cm wide in accord with my printer settings (A4 size), which is about 600 px. I want to set it up for typical screen use which means 800 px would be reasonable. I don't understand why I can't just grab the edge of the page in layout and drag it to the size I want. Is that too much too ask? It would seem so, as the only way i can find to do this is to change the print setup to landscape format instead of portrait. This is an unsatisfactory workaround, as it relies on the printer to set the screen size. Is there a better, simple way to set screen display size to 800px wide? Or better still, by checking the computer's display setup and formatting the layout to suit the computer user. (as can be done with web pages by getting the browser's setting)

I'm new to filemaker and trying to get a handle on it. When inserting a digital photo into a record, as a reference, a thumbnail is automatically generated and displays in the forms and list. I'd like to know where this thumbnail comes from. Is the thumbnail embedded in the .jpg file or is filemaker generating it when the image is imported? Further, if the original .jpg file is deleted or moved, the thumbnail persists in the database, leading me to assume it is stored in the database. I can't find any properties of the displayed thumbnail to determine it's size in pixels, or file size in Kb. I want my database to be efficient, so I need to control the thumbnails and know what I'm dealing with. (I think I'd prefer to generate my own thumbs into a subfolder using Photoshop and then import the whole lot including filenames and paths into different fields in a one step process). Another related question. I can't see any built in commands for importing the EXIF info from the photos. Any references to this are appreciated too.