I have a value list where the 1st field is text and the second a sequencing number to order the text when the list is displayed in a drop down list.

I would like to suppress display of the 2nd field in the drop-down list. I tried reversing the fields and using the 'display only values from the 2nd field' option, but it won't let me sort on the 1st field.

Is there any way to suppress display of a 2nd field in a drop-down list when that field is used only to sequence the entries in the list?

TIA

tomp

I'm not sure if I understand correctly, but I have a drop down list that is connected to a layout.

I have the fields sorted there within the layout. The drop down shows them the same way, and my 2nd field is not shown.

Not sure if this helps or not.