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 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.
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.
So If A->Z
A->3 records should be generated.
Is that what you’re looking for?
Contact me via the information on my website if you want to pursue this off-line. QuickBaseCoach.com
I do know that Quickbase has some new and wonderful things coming down the pipeline might let you do this with Automations,
It’s possible that if I combined my techniques with their techniques that this could be made to happen automatically. With no button push.
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.