2 Replies Latest reply on Sep 19, 2014 2:11 PM by KeithO'Hara

    Have container field that calculates and displays most recent image

    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?