Issue w/ Querying Counselor (CNF.SID) Field Information Related to Users from Staff (STF)
The Counselor (CNF.SID) field from the Counseling table does not return any values when it's used with the users from the Staff table. In other words, the information from the Counselor drop-down can't be queried. However, if a value not associated with the STF table is inputted that value is returned.
Gianna De Keles commented
The reports should be generating correctly using the drop-down menu. This shouldn't even be something we vote on, but rather something Aeries should recognize as a flaw in their system requiring attention/correction.
Tina Lessi commented
This is critical since we need to be able to pull accurate reports and ensure that input is correct.