Adding a New Record

  1. Select the Keys option

  2. Enter a key for the new record and press <Enter>. Press <Ctrl+P> to display the upper and lower limits for the field. Press <Insert> to insert the database default value. DP4 supplies the next unused number for a numeric field, and the default values for character, date and time fields

  3. If the key you have entered is used by another field, DP4 displays the record with the status: "Existing record"

    If the key is not in use, DP4 displays the status: "No matching record"

  4. Select the Add option. DP4 displays the details of the last record as default values for the record fields

  5. Enter the required values for the fields in the record. These will be validated against the field limits set when the table was created.

  6. When you complete the record entry and try to save the changes, BROWSER will perform any referential integrity checks specified for the table (for example parent checks). If you cannot add the record because of a missing parent you can switch the table you are working on to the problem parent and add the missing parent - when you return to this table your work will still be there). Alternatively you can run BROWSER from a command prompt and specify -ALLOW. This allows you to bypass both range and referential integrity checks. If you find yourself using -ALLOW a lot, then it indicates you should probably make changes to your database design (for example switch off a parent check that needs to be bypassed) using