musicarteca Posted March 1, 2006 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?
Reed Posted March 1, 2006 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.)
musicarteca Posted March 2, 2006 Author 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.
Reed Posted March 3, 2006 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.
Recommended Posts
This topic is 6849 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