We have a capital asset management application with a parent table Surface Lots and child table Documents. Each year, one of the documents placed in the Document table for each of the 179 Surface Lots is an engineering condition study that includes the date of the study and a condition rank for the asphalt and another for the parking space striping. I need to have the most recent study with the rankings update corresponding fields in each Surface Lot record. I've tried putting together a Quick Base Action, but cannot get it to work. The ranking fields in the Condition Study Document record are multiple choice text fields. I did set up a summary field for the study date in the Parent Table relationship, pulling the "maximum" date in order to get the most recent study. Ideas?