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 will 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, it will need three ID fields. Infor CRM will 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 it will not link the parent and child tables.
|
|
While some link tables that exist in Infor CRM only contain two ID fields, you should have all three ID fields in all link tables you create. |
