This is probably going to end up being embarassingly simple, but for now it escapes me!

 

In reading the FTS 11 book, p. 4-29, it comments how with drop-down lists, using the show-second-field only option, that after the selection, the original value (usually a keyfield) is the one that shows. It suggests using an non-enterable opaque related field that contains the values displayed as the second field in the value list. Users clicking on this field would activate the hidden field formatted as a drop-down list, make selection, and after exiting, see the data in the second field rather than the stored key itself.

 

My question is, how to do this? How does clicking in one field activate the other? Tried a ST and that wasn't successful. Since the field is non-enterable, I'm not sure any of the ST options apply, actually.

 

Thanks for any assistance.

How does clicking in one field activate the other?

 

Actually you are clicking in the "other" field, because the one you see is non-enterable.

Where I am confused is that the book says that the opaque field is directly on top of a field formatted as a drop-down list. 

 

So how would it click in the "other" field if it is directly on top of it?

 

Thanks for responding.

You turn off entry to the 'other' field (field behavior or in Inspector the Data > Behavior tab) so when you click on it, you drop down into the drop-down field.  :^)