Lookup multiple items from the same table.
I'm trying to set up a QA audit table with an accompanying form for staff to evaluate medical records. The problem I'm running into is both the auditor and the person whose record is being audited ar...
If you need to pull two different names from that table, they just duplicate the relationship and have two look up fields.
Yep. That did it. I didn't know you could have multiple iterations of the same relationship. Thanks a bunch.
