AnsweredAssumed Answered

Have container field that calculates and displays most recent image

Question asked by KeithO'Hara on Sep 19, 2014
Latest reply on Sep 19, 2014 by KeithO'Hara

Title

Have container field that calculates and displays most recent image

Post

Here's what I'm trying to accomplish, hope someone can help:

I have a main table, and then a separate table into which images are imported, along with import date, image type, filename, etc. The two tables are linked by a "Shot_ID" field… I will be importing new images for a shot into the image table, but will be keeping the old images as well… hence there will be more than one image on the image table with the same Shot_ID. 

I'd like to have a container field on the main page that will show the most recently imported image for that Shot_ID… I know I can do this with a filtered portal (filtering by date), but for whatever reason, my boss doesn't want to do it this way… so I'm wondering if there's a way I can set the container field on the main table to calculate and display whatever the most recent image for that Shot_ID happens to be… any ideas?

Outcomes