COPY FIELD COMMAND (6.1)

Select a field in Table Design and click the copy button. A new field is added following the selected field with all the same properties as the selected field. The field name assigned is the same as the copied field with number at the end of the field name incremented by 1. If the selected field has no number at the end of it's name, 2 is appended to the field name. Example: select a field called STATE. Click Copy 3 times, and the fields STATE2, STATE3, and STATE4 are added following STATE.

FIELD ALIAS (6.1)

The Field Alias for a newly added field can be changed at any time during the session it was added. Previously, after closing the field wizard, the alias could not be changed in subsequent calls to the field wizard. The Field Alias is useable in ADBM formulas in place of the Field Name. This is very helpful in keeping the fomulas concise if the Field Names are long.

4-DIGIT YEAR VALIDATION (6.1)

A new year format of YYYY (upper case) forces the user to enter all 4 digits of the year. The format yyyy (lower case) allows the user to enter only 2 digits. Numbers from 00 to 29 set the century to 20. Numbers from 30 to 99 set the century to 19. Entry of 1 or 3 digits produces a beep and the year is set to 0000, which will then prevent the record from being saved. Valid years are from 0001 to 9999.

CHECK BOX FIELDS (6.1)

Any numeric or Yes/No field can be given an Input type of Check Box. The Check Box can be toggled with either the mouse or the space bar. The field receives a value of 1 for checked, and 0 for not checked.

Sort Button (6.2)

Sort all the fields following the primary key fields in alphabetic order.  This causes all the lists of fields throughout the program to list the non-key fields in alphabetic order.

Link to Non-key Fields (6.2)

Link formats can link to non-primary key fields.  If non-primary key fields from the Lookup Table are selected for link fields, the Lookup Table must have a secondary key (index) created that contains the exact combination of Lookup Table link fields.  If there is only one link field, this will be a simple secondary key.  If there are 2 to 10 link fields, this will be a compound secondary key and it must contain the exact combination of link fields in the same order as the Lookup Table link fields.