AnsweredAssumed Answered

Dropdown menu design problem

Question asked by muhammad.ikram@contedia.com 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

Outcomes