AnsweredAssumed Answered

Dropdown menu design problem

Question asked by on Jun 28, 2018
Latest reply on Jun 28, 2018 by ThierryGuemboura

Hello Community,


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.


Many Thanks