Lookup multiple items from the same table.

Question

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 are employees and thus their names come from the same field of the same staff table. I could go the cheap route and make one of the 2 fields on the form a text block but I'd rather not. Is there a way to have a form pull 2 different names from a related table instead of locking on one?

Thanks in advance

MarkShnierYou · Accepted Answer

If you need to pull two different names from that table, they just duplicate the relationship and have two  look up fields.

EdwardOToole · Answer

Yep. That did it. I didn't know you could have multiple iterations of the same relationship. Thanks a bunch.

Sign up

Login to the community