Hi all,

I am new to this forum (and to Filemaker), and I hope this is the right place to ask this question:

I have a database where each record is associated with a variable number of images. so I have two related databases, a main database and a image database. Now I would like to be able to, in the main database, step through all related images (if I create a field that shows the related images only the first image is shown). How do I do that?

Thanks!

INgo

Hi Ingo:

There are a couple of ways to do this:

1. You could use a portal in the main db to show all the related images.

2. Or, you could have a script from your main db that goes to the related one, and constrains the images down to a found set based on a rec id key field. This way requires a little more work to make smooth, but I use it quite a lot.

Ken

Thanks, Ken!

Do I get you right that it is not possible to show one image at a time directly in the main database, without switching to the related image database? If yes, is it possible to open the related database in the same window?

Ingo

Yes with portal, or calculated field.

If you would like, I can send you an example of how this would work.

Ken

> If you would like, I can send you an example of how this would work.

Actually, that would be just great! I tried it myself and got kind of stuck.

Thanks a lot!

Ingo

This was made using the photo catalog from filemaker.com. Most of the features do not work because it was modified. There are two files: one holds client info, the other holds the pictures. The primary key for the relationship is RecID. The images are displayed in the main file using a portal.

If you have any questions, let me know.

Ken

Photo Catalog.zip