or I find another way to populate a join onto the parent record itself, such as embedding it in a custom field.