Value List Sorting Troublehshoot

[mandydawson]

I'm pulling my hair out over this one. I know I've seen the answer to this one somewhere, but no amount of googling seems to be helping me find it again.

 

I've created a value list that uses values from a "Drivers" table. The first field value is the DriverID, and the second is Full_Name. When I select to sort values using the Second Field, the value list shows only the first record from the Drivers table. 

[eos]

Not much info to go on. The IDs are all different (just asking …)? The names are all different (and existent), and both fields are indexed?

[mandydawson]

Yes, DriverID is indexed and are all unique. Full_Name is a calculation, indexed "First_Name & " " & Last_Name" and are all unique.

[comment]

Full_Name is a calculation, indexed "First_Name & " " & Last_Name"

 

Make sure the calculation's result type is set to Text.

[mandydawson]

Brilliant! It worked. I knew I was overlooking something simple! Thanks.