Jump to content

Pictures in a portal


tigerpower
 Share

This topic is 5794 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5794 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.