Dynamically Fetching Lookup Field Display Value
I have an audit trail form, Audit_Changes, that tracks old vs new values across different forms.
For lookup fields, the old/new value is the ID, but I also need the display value.
What's a best practice for dynamically fetching the display value of the lookup field, assuming I can't hardcode the form name in the fetch, e.g. Status[ID == <some ID>], but I will have the form name and ID readily available.
Note, I'm using environments, if that makes a difference.