Forum Discussion
MCFNeil
Qrew Captain
This is a fairly common need. You will have 4 tables involved.
Provider -> (has many) Case Workers
Provider -> Cases
Cases -> Case Assingments
Case Workers -> Case Assignments
The "Case Assignment" table is your joined table (sometimes incorrectly called a many-to-many).
The kicker for this one will be to make sure that the "Case Worker" dropdown on the assignments table is conditional upon the [Related Provider]. That way you will only display the Case workers that are assigned to that particular Case.
Does that help? Let us know if you are stuck anywhere.
Provider -> (has many) Case Workers
Provider -> Cases
Cases -> Case Assingments
Case Workers -> Case Assignments
The "Case Assignment" table is your joined table (sometimes incorrectly called a many-to-many).
The kicker for this one will be to make sure that the "Case Worker" dropdown on the assignments table is conditional upon the [Related Provider]. That way you will only display the Case workers that are assigned to that particular Case.
Does that help? Let us know if you are stuck anywhere.
PhelanSanders
7 years agoQrew Assistant Captain
Worked! I appreciate it!!