Every item, from the main menu leads us to Step 2, which is a Lookup Window...

There are a few things to learn about a lookup window, for starters, please note the graphics near the top of the window... You can use these graphics to do several types of operations... If you want to add a new State to the list you press  (Insert Button), and an Edit Window will display, where you can add a new entry.   To edit an existing entry, you move the highlighted area of the lookup to the desired selection and press the (Edit button), in the example illustration above, ID-Idaho is selected.  To remove an entry from the list, you simply click on the (delete Button) and the entry will be erased (after a warning prompt).   

If you prefer using the keyboard only, another way of adding records is by pressing the Insert key, delete records by pressing the Delete key, or edit records by pressing the Enter key.

Navigating

To navigate from record to record, you have several options, you can use the graphic buttons,

click  (First Button) to move the first record in the list, click  (Last Button) to move to the last record in the list.  Click  (Previous Button) to move to the previous record, or finally click  (next button) to move to the next record.

Another way to navigate the records in a lookup window is to press the up and down arrow keys, up to move to the previous record or down to move to the next record.  You can also press Page Up and Page Down keys to move one page up or down.  To move to the first record in the list press the Home key, or press the End key to move to the last record.

Lookups are always sorted, however, you get to decide which column they are sorted on. By default the lookup is sorted by the left most column, in this example, the list is sorted by State codes, you will know this, because it is the column that is highlighted.  To change which column is sorted, you simply click on the header of that column.  Example, click on the description column, it will then be highlighted and the lookup will be sorted by description.

By right clicking with the mouse, anywhere on a lookup, you call up a popup menu.  This menu allows you to do several functions, as well as several advanced functions.  The basic functions available from the popup menu include:

Display Columns

• List - To display a report on the screen, which can then be sent to the printer of your choice.
• Create Browser Report - To display a report inside your web browser, this is useful if you want to make a web page out of any report.
• Email Report - To email the report directly to someone, or a list of people.

By selecting this option, a report is created for you, the report will take the form of some of the previous options you have selected.  The report will be sorted on the column you have selected for a sort and the report will include only the display columns you have selected. In effect giving you a very powerful report writing tool.

If you move the mouse over any of these fields you will see the hint...

This means you can double click the mouse on any lookup field, or press the F3 key, and Flame XE will open a lookup which will be a list that you may select your entry from.

If, for example, you double click on the State/Province field, you will get a lookup, much like this one...

But here is the secret behind this powerful combination... When the States/Provinces Lookup is displayed, if for some reason a state that you want doesn't exist on the state list, you can add it straight from the lookup window, following all the rules of Step 2 (Lookup Windows).  So imagine you are entering an order, and the client you want to enter the order for, doesn't exist... You add them to the lookup, and select them immediately, but if while adding that client, you notice the country that they're in, doesn't exist, you call up the country lookup.  The levels you can zoom in, is unlimited.