help_outline FAQ chevron_right FAQ chevron_right Detail

What SQL query is used to populate the Department_List field in the Department Entry form?

department query sql department_list entry field

The SQL query is: SELECT RM_DEPARTMENT_ENTRY.UserTableID, RM_DEPARTMENT_ENTRY.Department FROM dbo.RM_DEPARTMENT_ENTRY WITH (NOLOCK).