PeopleSoft 8.8xxx

Need Data Returned From Two Tables Using One of Two Prompts

Hello everyone,

I am using PSoft Query Manager (Ver 8.8xxx - Web Based.) Here is what I need to do.

I need to use a Prompt to enter the RESUME_TEXT_FILE from the PERS_APPL_INFO Table
I need to use a Prompt to enter NAME from the HRO_DASHBOARD Table.

The RESUME_TEXT_FILE contains 7 characters for each entry, it is a unique entry, and corresponds to an EMPLID in that same Table

Not all employees have a RESUME_TEXT_FILE entry in that Table. Employees who do not have the RESUME_TEXT_ENTRY simply do not appear in this Table.