Complex Table Relationships Question
I currently have the following:
An employee table (built already)– where each individual gets a row with their demographic info
An annual employment snapshot (built already) – where each indivi...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSeems easy, and you seem to have figured it all out.
One employee has Many Annual Employment Snapshots.
One Employee Annual Snapshot has Many Annual Snapshot Mentor Assignments (new table that joins with Mentors and Annual Snapshots as its two parents.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
One employee has Many Annual Employment Snapshots.
One Employee Annual Snapshot has Many Annual Snapshot Mentor Assignments (new table that joins with Mentors and Annual Snapshots as its two parents.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------