Container Calculations?

[Wickerman]

I have a table with information about films that includes 6 container fields with images from the film.

I want to create a layout that will print a label for each film featuring *1* of the 6 images depending on the user's selection.

I was thinking what I could do was to havea field that allows the user to enter a number from 1 through 6 corrsponding to the image of choice and then run a simple 'Case' calculation that would read the number and enter the appropriate image in a 7th container field called, say, 'LabelPicture'.

I've been tinkering, and it seems as though I can't get Filemaker to enter container field data via a calculation -- I think I may have read that this isn't possible someplace?

So, I guess could just have the user drag the image from one container field into the 'LabelPicture' container -- that's aboit as easy as entering the numbewr of choice anyhow. . . but I've gotten curiosu aobut whether there's a way to do this more elegantly, and perhaps without duplicating the image data, which I guess would grow the size of the file somewhat redundantly? I'm assuming conditional formatting would involve the same sort of container/calculation issue . . .

Thanks!

Albert

[mr_vodka]

You need 2 tables here. One for the file information and another for the images. You can then have your user click on button and select which related image record they want to select to print for each film. You can then use go to related record and then you have your found set to print.

[comment]

it seems as though I can't get Filemaker to enter container field data via a calculation -- I think I may have read that this isn't possible someplace?

It's possible, if you set the result type of the calculation to Container. However, I agree with John that you should keep the images in a separate table, with each image being a record. It is then easy to select the image by placing its unique ID into a "SelectedImageID" field in the parent film record. If you establish a second relationship between the two tables (matching SelectedImageID to ImageID), you can place the related image on a layout of Films, and print from there.