Database Relation
|
In this field, you can specify the name of a relation in the Maconomy database if the current note relates to an entry in a given relation. In the remaining fields in this island, you can then specify the entry in question.
Please note that the note can be assigned to any type of information, regardless of any relation name entered here. This means that although you specify a relation here, the note can still be assigned to sales orders in the workspace Sales Orders, events in the workspace Events, and so on.
|
<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 note 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 constitute 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 sub-tab 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.”
Please note that the note can be assigned to any type of information, regardless of any information entered here. This means that although you specify key values here, the note can still be assigned to sales orders in the workspace Sales Orders, events in the workspace Events, and so on.
|