1. State-up, City-up
2. State-up, City-down
3. State-down, City-up
4. State-down, City-down
5. City-up, State-up
6. City-up,State-down
7. City-down, State-up
8. City-down, State-down

State-up, City-up != City-up,State-up

Here is the practice exercise: A two-column subfile; State & City.  Click either heading and sort by that column. Clicking a column heading a second time reverses the sort.  Maintain the current sorting order for the non-clicked column.  This is the same behavior that we see and are used to in our e-mail folders.

On 12/13/2019 6:57 PM, Jon Paris wrote:
If you have two keys the worst case scenario is 2 procedures, A in B, and B in A. Unless you also need A only and B only. That would be four procedures but could be achieved by just two and short circuit logic when a single key was needed.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.