Jump to content

Sorting value list by a third field


musicarteca
 Share

This topic is 5680 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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

This topic is 5680 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.