Adding Records in Admin Pages

When adding a record using the admin page you need to enter all relevant information into the form except the record’s primary key. The primary key will be assigned automatically by the system when the record is added. Pressing the [ Add Record ] button will add a new record containing all the information you entered. The newly assigned primary key will be displayed on the form once the add record operation completes.

In the illustration below the primary key is the customerid field. In other records the primary key will have a different name (see list of primary keys for primary DB tables). The Primary key is always the first field in a record (with the exception of e-coupons).

Note: Primary keys are used by the system to maintain records and linkage between DB tables. The primary key should never be used for outside record identification or for other similar purposes. The primary key could be changed for future records which are for the same object and as such is not suited for outside identification purposes.

Hint: When first entering records into the database it is often easier to use an existing record already in the database as a template. The database you have received will contain sample records for items, customers, etc. It is much easier to start with a record that works and modify it to fit your needs. To do this follow these steps:

1. Load the existing record you wish to use as a template into the admin page (Use the FIND function to identify and load the record you wish to use as a template).
2. Modify the fields which you want changed (often this is only three or four fields)
3. Press the [ ADD RECORD ] button
4. That's it! You have created a new record in the database.