I have two forms. The first form is used to store Project Type such as "Type A", "Type B", etc. and has only one text field. The second form store Projects and includes a text field for the Project Name and a dynamic field for Project Type (pulled from Project Type entries).
I'm trying to create a search form to allow users to select a Project based on Project Type and Project Name. The user first selects a Project Type then selects the Project Name,  The Project Name in the search form is a lookup field watching the Project Type so only Project Names matching the selected Project Type appear.
The search for works but the text that appears in the Project Type shows the entry number of the Project Type rather than its name (e.g. "Type B"). Is there a way to display the Project Type text rather than the entry ID?