Forum Discussion

GiuseppeMacri's avatar
GiuseppeMacri
Qrew Captain
8 years ago

Create new child records based on a parent table report

Hi, I have 4 tables, Employee, Assignments, Organization and Site. The Organization table is the parent of the Site Table.  The employee and organization tables are a many to many relationship w...
Ask about Quickbase functionality
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
I would change your schema to the following and possibly set the record picker fields for the Sites table to be the [Name] of the parent Organization and the [Name] of the Site.



This will allow you to join an Employee with a Site and independently manage Sites as children of Organizations. This new schema also implicitly joins Employees to Organizations.