SELECT Form = "Main Topic"
The first column is sorted and its formula is:
@Text(@DocumentUniqueID)
Create an agent that runs on a schedule, selects all documents in the database that use the form "Response," and runs the following formula:
FIELD Project := @DbLookup("":""; ""; "By doc ID"; @Text($Ref); "Project");
@All
Each time the agent runs, it performs a lookup in the "By doc ID" view to find the "Main Topic" that is the parent of the current "Response" (that is, the document with a @DocumentUniqueID that matches the current document's $Ref field). It then copies the contents of the Project field from the parent to the child.