Create new child records based on a parent table report

Are you saying that you would create a new many to many relationship between employees and sites called employee site assignments, and then want to automatically have those Assignment records created when in employee is assigned to an organization, for example an assignment organization Z.

Is that what you�re looking for?