AnsweredAssumed Answered

trying to match records in different tables

Question asked by rubinjm on May 24, 2018
Latest reply on May 24, 2018 by Jaymo

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?