Last year, in Custom Field-Based Value Lists, we looked at a technique to enable single-column field-based value lists to display their contents in entry order, as opposed to standard index-based alphanumeric order. For example using the contents of this field (from a single-record table) as the basis for a value list…
…we came up with a way to sort our value list (a.k.a. “VL”) items like so…
…as opposed to what you would get with a standard field-based VL, i.e., this:
I ended the article by saying…
Today’s article looked at value lists based on return-separated values in a single field. In an upcoming article we’ll explore implementing a similar technique for sorted two-column value lists based on entries in a dedicated value lists table where each list item lives in its own record.
…and now, nineteen months later, am ready to pick up where we left off last time, and to avoid repetition, will assume the reader is at least somewhat familiar with the issues and techniques covered in that article (Custom Field-Based Value Lists).
- 2-column value lists, v1.zip — independent value lists
- 2-column value lists, v2.zip — dependent (cascading) value lists