I have a database of patients with ultrasounds performed. There is a medical record number field that is a unique identifier. There is also the visit date.
I have a separate list of dates and medical record numbers for patients that arrived as a "Trauma Alert." I'd like to be able to identify the patients in the master database who were a Trauma Alert. I was thinking about a field that used Case logic but not sure how to set up the lookup. Any better ways to do this?