Hi Forum,

I hope I am posting in the good section. I am a newbie in Filemaker Pro and am I doing my very first database.

In the database (people) I have for every record a picture of the person. But people can have several pictures and I would like to be able to choose witch one from the list would be on the first page.

Ex: In a data base of models, there is the main record of the model with all the details and here picture. Then there is on an other layout all her pictures. I would like to be able to choose from all her pictures the one that would be showed on the main layout.

Any ideas how to do this?

Thanks for any help

Steven

Assuming you have a separate table (or file) to hold the images then you should make a RELATIONSHIP between PEOPLE and IMAGES. You will need a field in PEOPLE - say PERSON_ID - in both tables and use that as the link between the two tables. Make sure it's set to AUTO-ENTER with a SERIAL NUMBER that increments by 1 each time. That way you guarantee a unique record in PEOPLE.

You will need a PORTAL (based on the relationship described) to enter new images for each person. A simple button to use the SET FIELD function can then copy the PORTAL image into the main image in PEOPLE.

HTH

Hey Ideal,

I was with you until that last step.

Rather than moving that image around, it's more efficient to grab the ID of the Image record and put that into a SelectedImageID field in the Person table. You would then have another relationship between Person::SelectedImageID adn Image::ImageID, and use that to put the related Image field on the layout.