Primary key
A primary key is the field, or set of fields, that uniquely identifies each record in a table and is never blank or repeated.
What it means
Each customer, item or invoice needs one reliable handle. A name will not do because two customers can share one; a system-generated number or code can. Other tables refer to the primary key, so it should not change once used. Choosing it well avoids duplicates and keeps links between records stable over years.
Example
A chemicals trader gives each item an internal ID such as ITM-00457 and keeps the long description separate. When the supplier renames the product, only the description changes and every old transaction stays linked.
Records and checks
- Record which field is the primary key for each table and how it is generated.
- Verify there are no blank or repeated values after any import.
- The data owner confirms the rule before records are loaded.
Common mistakes
- Using a name or phone number as the key, then finding two people share it.
- Reusing a deleted ID for a new record, which confuses old transactions.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →