There is a maximum of one
Primary Keyper table, whereas a table can have several
alternate keys. The
primary keyis usually the type of key that other tables, called child tables, refer to when a
foreign keyfield in those other tables need a relational identifier.
For new tables the default is a
primary keybased on the
RecIdfield , incremented number or a completely meaningless number that is generated by the system
Alternate keycan be chosen as the
Replacement Keyof a table that can display on forms instead of a meaningless numeric
primary keyvalue. Each table can have a maximum of one
Natural keyhas meaning to people. Most
Relations represents a
Thank you for reading!