musicarteca Posted March 1, 2006 Share Posted March 1, 2006 I have a value list based on a key number that displays a second field which is a part number, a combination of texts and numbers. I have created a new field for sorting the part number by its internal numerical value, but how can I display the complet part number and have the VL sorted by its numerical value? Link to comment Share on other sites More sharing options...
Reed Posted March 1, 2006 Share Posted March 1, 2006 You'll have to create a calculated field that concatenates the two fields that you want to display, beginning with your sort field (padded with enough zeros to make the text field sort properly as a number.) Link to comment Share on other sites More sharing options...
musicarteca Posted March 2, 2006 Author Share Posted March 2, 2006 OK, but what do I do with that field, I cannot display it in the value list because it will be confusing for the user. I have already created a calculated field that extracts the number from the part #, I use that for sorting the records on the correspondent table, but I am stuck with the value list. Link to comment Share on other sites More sharing options...
Reed Posted March 3, 2006 Share Posted March 3, 2006 use a portal instead, then you can show whatever you want, with a lot fewer restrictions, and sort by any field. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6629 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