I perform surveys by taking photographs of all the persons I encounter but each person can only be encountered once per survey. The survey table has a nested table with the individuals encountered, but each individual has a nested table listing all the photographs taken during that encounter. I want to flag one photograph from each encounter (the best for that individual). Then, from the best photo of each encounter, I want to flag the best overall photo for that individual. I've attached a sample of the database I'm using and how I am trying to make it work. I am trying to use the "set field" to flag the best image filename and add it to the parent table, then using the matching filenames to display the photo. From a table of best photos, I want to flag the overall best and using "set field", send that filename to the "best overall photo" table, and once again display the image by matching those filenames. For some reason when I set the field, the filename does not get passed up to the parent table.

The other method was to flag the child image with a "yes" field to indicate the best one. Then show that image in the parent table through a relationship where the parent table has a field that is always set to "yes". I've spent a ridiculous amount of time trying to get this to work properly but can't seem to get it quite right. Any help or suggestions would be greatly appreciated.

BestPhotosNested.fp7.zip

The best image of an encounter is an attribute of encounter and should be recorded in a BestImageID field in the Encounters table. Similarly, the overall best image of an individual should be selected by populating a BestImageID field in the Individuals table.

So would you do this with a "Set Field" script? In the images table (grandchild table), setup a button next to the image I want to be the best encounter image that populates a field in the encounters table (child table) with the imageID? Then display that image via a relationship between ImageID and BestImageID? And then do the same in the encounters table, with a "Set Field" button that populates a field (BestOverallImageID) in the individuals table (Parent table) with the BestImageID of the encounters table? Then show the best overall image via a relationship between BestOveralImageID and BestIMageID?

More or less, yes.