I'm using FileMaker 17.
I am having design issues with a dropdown field. I have a dropdown field "Project"; it looks at value list which has the list of projects names.
The way I done is here.
Here is the field.
When I click the drop-down I see all the names, but when the list is hidden; it shows ID ONLY. I really dont want to see the ID; I would like to see which project I selected.
One way I tried doing is by creating another table accourance; set the relationship so I can see the project name. It works fine.
But my question is; is there any better way of dropdowns. If we are displaying the values from second field; is there any better way so we don't see the ID but project name. Its FM 17 and dropdown still are same as first 14.