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
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

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?