Have container field that calculates and displays most recent image
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?