Good afternoon Daniel,
I hope your day is going well. If I'm not mistaken, I believe the intended function of the "Also display values from 2nd field" if for display purposes only. It should only place the first value into the field with the control style set to drop down list. You may be able to configure the field to use a Lookup to replace the value inserted via drop down list selection with the desired field value, provided that does compromise some other functionality. Hopes this helps. Have a great day!
My days has been quite well. Thank you for asking. The question is why does it show the "text" and not the serial number when it's a Popup Menu? You only get the text when selecting a Drop-Down List then it shows the serial number (first field.). I've used this method for years. I've attached examples. I created a simple table with three records. The Value list is: First field is "pk_id" (populated with Get(UUID). The second field is "Data" and the record values are horse, cat, dog. The value list is set to Show only second value. I applied the list to a field called "Result".
So, in the first screen shot you see that the Drop down list is showing the values in the list. The second screen shot shows the result after selecting a value. It shows the serial number in the one formatted to use Drop Down List and the second one displays the 2nd value, Dog.
The bottom field is the same field but as an edit box and you should see the serial number. Doesn't matter if you select the value from the Drop Down list or the Popup List, the results are the same. So, why doesn't Drop-Down List show the second field?
Add a tab stop to each of the two fields.
It sounds like Pop ups are demonstrating your preferred behavior. Why are you using Drop Downs instead of Pop ups?
In my experience, I never use Drop Downs with the "second field" issue. Drop downs allow users to type into fields, something I never want in a field storing a unique ID.
Drop down list allow users to enter the field and edit value anyway, so it shows the entered value, not from the list after selection.
I built a table that holds commonly used terms by someone on patrol (missing child; illegal parked car; violation of rules. Etc) so they don't have to type commonly used terms over and over. These would be used as short descriptions for reports. Some terms are more common to a location than others so the table also holds the location ID. So I was attempting provide the user the entire list from all locations and one narrowed to the location (much shorter via a related filter). I don't want to give them direct access to a static value list because they might change existing terms. But how to add new terms? If they don't find a term they need they can add one by clicking again in the drop down and adding it. They could then click a button and it would add the term to the table with that location ID. But they could also find a term commonly used at another location from the long list and add it to their location using the same button. There are 2 value lists produced out of the table, one has everything and one is filtered by the relation. A second entry field uses the popup with the filtered list.
I think the flaw is my attempt to use a serial number to ID the term. I wanted to use the ID for statistical purposes so I could alter the label and not affect existing stats that were pulled into a report generator via SQL.
I had to juggle temporarily using a newly typed in term until it could be replaced by an ID.
As I think about it, if I need to change a term I'll just find all instances and change the term. I might drop the use of the UUID and simply rely on the label. Less moving parts. I think I just made it overly complicated. But it still puzzles me the two field controls don't act them same. (Someone suggested adding tab stops. I did with no affect.)
Sent from my iPhone
If you need to show 2nd value, you can use 2nd field from related table.
Put it over the drop down field. Make it un enterable (at least browse mode) and remove tab order.
When you click the field, you will enter underlying drop down field.
I also just realized that I have no control over the iPads in the field so if someone uses a different iPad in the same location I have no control over the UUIDs so using them for statistics would be a management nightmare. Better to stick to the terms.
Popups allow that, too, if you enable "Allow entry of other values", but that's just looking for trouble when using a Show second field list...