Several pictures per record

[monsnow]

Hello,

What is the best way to have access to several pictures per record. Most of my records have one photo, but some may have up to 15 or more. I currently just use one photo container per record.

Also if there is a way to click on the picture to enlarge, please offer your solution.

Thank you,

Michael

[Wim Decorte]

Either you create more container fields to accomodate for more pictures, or you re-think the structure. It would seem to me that the pictures are children of the record, so you would use another table to store the pictures in. That way any record can have 0 to unlimited pictures associated with it.

To enlarge: create a new layout with the same container on it but bigger. Set the graphic properties to 'enlarge'. Then use a script overlayed on the original small container to take the user to the new layout with the big container.

[monsnow]

Thanks for your response Wim,

I did not consider creating another table. When I view my records in a list format, it takes FM a long time as it is generating each picture. If I created a separate table, I could then create the list without creating each picture.

I will try your suggestion regarding enlarging the picture. Sounds like that would be the likely solution.

Again thanks,

Michael