Concatenate multiple rows from one table into single field in another



I want to automatically populate any new row with the concatenated results of a query of a single field from another table. eg For a new row in table A, I want to select column X from table B and concatenate all the “X”'s into a field in this new row…