Using CR 9 with a MS SQL db
Patient database, tables: tbPatients (name, ID, AlertID), tbPatientAlerts(alertID, alertDesc)
Alerts contains "Collection", "Call Dr. Office", "Print Film", etc.
Need to show Section with "Patient in Collection" if "Collection" is selected in table tbPatientAlerts, and not show if any other alerts or no alerts are selected.
I can do basic stuff but...