Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Sort records (for list); specific items first

Featured Replies

I have a keys database: what keys have been assigned to a person or location.  so i need a list of these people (scott, bob, smith) or locations (key box 1, key box 2, binder 1).  How can I put the list so that locations are first and people are 2nd (in alphabetical order) like this:

Binder 1
Keybox 1
Keybox 2
Bob
Scott
Smith

Thanks in advance.

I don't understand your question. These are records in the same table? What fields does this table have? How can one tell the two types apart? 

And what does the "(for list)" part in your title mean?

  • Author

Whoops sorry. yes they are all records.  so I have 1 table "Issued List"  it has a "Name" field, which would have the name of the location or name of the person.  

so I create a List based on this table and at the "Name" field.  now I have to get the order correct. that's where I'm stuck.  I have about 10 locations and 100 people.

So you have answered my first question (I think). Three more to go...

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.