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
Thanks Mathew,
I have created the tables above, however, I believe I am now having issues with the conditional Dropdown. It is giving me the message "First choose a Provider Staff (Case worker)" in the assignments table. I will like to only show those case workers related to the provider.