Best Practices for Browsing Records

Browse tables show you a list of related items. The one on the left shows a list of part numbers. Items in the list are usually sorted by the first column. Sometimes there are more columns displayed to the right. You can use the horizontal slider control to scroll the list to see other items.

You can move through the list by pressing the cursor up & down keys. You can also move by clicking in the vertical slider region.

To locate an item quickly, just start typing. In this list of part numbers, pressing the "5" key would move the selector bar to the first part number starting with "5". Pressing "4" next would move to the first part starting with "54". This is a very fast way of locating items.

You can change the order of items in the list by clicking on the header column you wish to sort by. Clicking a second time reverses the sort order. Holding the Ctrl key down while clicking an second or third column adds that sort. For example, you could sort customers by state, then click Ctrl-ZipCode to list all customers sorted by state, then by zip code. You could even add a third click on the customer's name to arrange the customers alphabetically in each zip code.

You can also select which columns to display. Right click on the column descriptions and select "Columns..."

You may also change the displayed order by left clicking and dragging the columns into the order you desire.

MasterQ will remember which columns and the order you wanted to view the next time you run the program.

Browse tables may be filtered to display only the records you are interested in. These filters may be quite involved if required and may be easily saved for re-use later. NOTE: the filters you save are yours exclusively and are not shared with other users of the program.

Once you have sorted, filtered and arranged the information the way you want it, you can export it to an Excel spreadsheet with just a click of the button.

Right click anywhere in the listed data and select "Copy to Excel"

Find out how to get MasterQ here!