Get property of record using only ID

Get property of record using only ID

Hi there,

We have a Project form, a Job form, and a PO form. The Job form has a lookup field that links to the Project form's ID but displays the Project's Name. The PO form has a lookup field linking to the Job, but I'm not able to have it display the Project Name associated with the Project ID that is referenced in the Job form rather than the ID itself.  Any way to do this?

One way to do this would be to create a formula where it finds the Project where ID == something and then get another property from that found record...something like this inside of the PO form:

  1. Project[ID==input.Job_Project_ID].Project_Name

Any ideas?

Thank you,
Eric