I have a table called Projects with these fields:
Project Name
Client Name
Project Number
I have a text formula called Full Name which is Project Number + Client Name + Project Name
I have another table called Inventory that is connected to Projects. When I am creating a new item in Inventory, the dropdown for the connected record shows the Project Name. I want it to show the Full Name.
Any ideas how I can do this?