Just wondered if there is a way to look up a picture from a nother file. If you have the relationship set with two number fields, Can filemaker lookup the picture and bring it to the second file. Or is this a portal . Function. Somehow , I have to accomplish this.

Thanks

Stan

Version: v7.x

Platform: Mac OS X Panther

If you already have a relationship, just stick the picture directly on the layout of the second file. Using the field tool, choose the relationship, then the name of the container field with the picture.

If you want to be able to find records that are missing their pictures, that's another issue. You can't run a find on a container field, but you can make a calculation field in the second database like:

If (IsEmpty(PicRelationship::Container), 1, 0)

This field will have a one if the picture exists, and a zero if not. Do your find on this field and you can isolate records missing their pictures.

Steve Brown