mandydawson Posted September 30, 2013 Share Posted September 30, 2013 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. Link to comment Share on other sites More sharing options...
eos Posted September 30, 2013 Share Posted September 30, 2013 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? Link to comment Share on other sites More sharing options...
mandydawson Posted September 30, 2013 Author Share Posted September 30, 2013 Yes, DriverID is indexed and are all unique. Full_Name is a calculation, indexed "First_Name & " " & Last_Name" and are all unique. Link to comment Share on other sites More sharing options...
comment Posted September 30, 2013 Share Posted September 30, 2013 Full_Name is a calculation, indexed "First_Name & " " & Last_Name" Make sure the calculation's result type is set to Text. Link to comment Share on other sites More sharing options...
mandydawson Posted September 30, 2013 Author Share Posted September 30, 2013 Brilliant! It worked. I knew I was overlooking something simple! Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3886 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now