ID Fields in Tables

Every table has at least one ID field that is used to ensure that each record in the table is unique. When a record is added to the ACCOUNT table, a value is automatically entered in the AccountID field. Each time a record is added, a value is generated based on information in the key file.

Which fields are the important ID fields of a table depend on the type of relationship that the table has with other tables. Any table that is created that is not linked to any other table will have an ID field unique to itself. If a new table is created as a child table with a One to One relationship with another table, its ID field will be the ID field of the parent table. If the child table has a One to Many relationship with another table, it will need more than one field to ensure uniqueness. Thus, it is automatically generate two IDs when the table is created: one unique to the table, and one that is the ID field of the table it is based on. If a table is a link table meant to resolve a Many to Many relationship, then this requires three ID fields. Infor CRM can only auto-generate two IDs, one unique to the link table and one for the primary table. You must add the ID field of the child table when creating the table or this cannot be linked to the parent and child tables.