<Key 1-4>
|
In these fields, you can enter the values in the primary, secondary, and so on, key fields that identify the entry in the relation above which the current contact group concerns. A key value is a value identifying, for example, a certain order, vendor invoice, and so on.
In certain relations, a key consists of up to four key fields. In these relations, the combination of the key values constitutes the key to the individual entries in that relation. An example of this is order lines, where the first key value points to the sales order to which the line in question belongs, and the second key value is the line’s line number in the table part of the sales order. So if the key to entries in a given relation consists of several key fields, it is possible for several entries to have the same value in the same key fields, but there can be no more than one entry with the same combination of values in the key fields in question.
When you enter a database relation in the field “Database Relation” above, Maconomy shows the names of the individual key fields in this island instead of blank field names, allowing you to see which fields should be completed.
If you specify an instance key in the field “Object, Instance Key” above, the key fields are automatically completed with the key values from the database entry to which the instance key value belongs. Similarly, if you enter key values in these fields and instance key registration has been activated for the database relation in question, Maconomy automatically completes the field “Object Instance Key.”
|