Create new child records based on a parent table report

Question

Hi,I have 4 tables, Employee, Assignments, Organization and Site. The Organization table is the parent of the Site Table.&nbsp;The employee and organization tables are a many to many relationship where Assignments is the intermediary table.If a user would like to assign an employee to multiple sites from its parent org, what would be an easy programatic way for them to do so, without having to make an assignment record for each site under each org.

chrischris · Answer

I would think that to make these assignments more dynamic the relationships would be like this::

Site >> has many >> Assignments

Employee >> has many >> Assignments

Organization >> has many >> Assignments

This will allow more dynamic selections of Organizations to Sites, Sites to Organizations, Employees to both Sites and Organizations all via the many-to-many Assignments table.

Your thoughts?

_anomdiebolt_ · Answer

I think this ER Diagram (created with creately.com) represents your existing schema:Are you trying to modify this schema or do you want some type of automation to fill in child records using the existing arrangement?

giuseppemacri · Answer

Yes, so if Employee A was assigned to Organization Z (who has Site 1, Site 2, and Site 3 Child records), I want to programmatically add additonally assignment records for all the sites under Organization Z.So If A-&gt;Z&nbsp; &nbsp; &nbsp; then A-&gt;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A-&gt;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A-&gt;3 records should be generated.

quickbasecoachd · Answer

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?

giuseppemacri · Answer

Yeah that. I was initially thinking it was possible via QB Actions but i cant figure out how to pass the Site IDs to the assignments when this action would be triggered.

Forum Discussion

Create new child records based on a parent table report

Related Content

Many parent records on a single child record

Totaling Child Records Live on Parent Form

create pipeline to create new records based on current record

Add child record through parent form and redirect back to parent form in edit mode

Create A New Record In the Parent Table from the Child Record's Information