For example, let's say you want to generate a list of plants found at a particular location. Btree indexes also support partial searches. There are two specific characteristics you should know about Btree indexes that will help you to use them effectively. First of all, an index will not be invoked when searching for a null value. In order to create a list manually, a bit of background information is in order.
Every record has a record key, which is assigned during the data entry process.
In some cases the key is simply a sequential number assigned automatically by the system, while in other cases the key is assigned by the user. This will call the TEXT editor and present you with a blank screen. Like any list, these records can be retrieved using the GET-LIST command and displayed using the LIST command. If you have this information, then using this technique may be the best way to create and store a list. You can also manually create lists in Advanced Revelation .