image step through

[ingow]

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

[kenneth2k1]

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

[ingow]

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

[Anatoli]

Yes with portal, or calculated field.

[kenneth2k1]

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

Ken

[ingow]

> 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

[kenneth2k1]

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