Primary Index Maintenance

A primary index is a key value that identifies a database record as unique. QAD CSS stores primary index information in an internal database table for use in application development. The Primary Index Maintenance function lets developers establish primary key definitions for QAD CSS maintenance modules and internal data translation relationships. Values set up in Primary Index Maintenance must match the primary index in the physical database schema. This information is stored in a separate QAD CSS table to improve system performance and efficiency.

Primary Index Information in Contact Maintenance shows an example of how Primary Index Maintenance is integrated into Contact Maintenance. The Detail Contact Maintenance screen shows the primary index field in blue as a required field.

Primary Index Information in Contact Maintenance

The menu location of Primary Index Maintenance is Home Menu|Administration Menu|System Control Menu|Primary Index.

Note: This is an advanced feature. Consider restricting access to authorized developers.

Clicking the Primary Index Maintenance menu option displays the screen in Primary Index Maintenance.

Primary Index Maintenance

Primary Index Maintenance Navigation summarizes the contents of the Primary Index Maintenance navigation screen.

Primary Index Maintenance Navigation

 

Column	Search	Search Type	Sort	Description	Link
Table	Y	Contains	Y	A word used to designate a database table. This table must exist in the QAD EA database.	Y
Field	N	n/a	N	A word used to designate a database table element. This field must exist in the QAD EA database table.	N

Related QAD CSS functions:

•	System Registry Report