Hello James,
You can use hooks to update the dog info collection each time a new record is added to the field results collection. For example, using afterUpdate .
Simply add a hook to the field results collection, select afterUpdate, and use the item and wixData update to update the relevant record in the dog info collection.