Dependant table

Presentation

The principle is to link a miscellaneous table B to a miscellaneous table A that will be principal, then to link each element in the table B to an element in table A. The entry of the element in table B will therefore be conditioned by the value entered for the element in table A.

However, it is possible to not link an element in table B with an element in table A and in this case this element is available irrespective of the the value of the element in table A.

A table can be dependent on a single table. On the other hand, it is possible to establish successive dependencies (example : table C dependent from table B, table B dependent from table A etc.).

Use in the definition of the miscellaneous tables

In table B, load the field "Table dependence" with the code from table A. This field is in fact used to link a miscellaneous table to another table that will be the master and therefore generate a hierarchy between certain miscellaneous tables. ( eg :the statistics groups and sub-groups ).
Miscellaneous table table definition function

Entry of the miscellaneous tables

During the entry of table B, any element can be assigned to an element in table A. In this case, the entry of this element (table B) in one of the X3 product screens, will therefore be conditioned by the value of the element from table A.
Entry of the miscellaneous tables function.

Screen dictionary

Outside of this miscellaneous table management, when a field is declared for the entry of an element from table B, it will be of the data type ADI, the number of the miscellaneous table from the daughter table, then the value of the field containing the code of the parent table. The name of this field (preceded by the abbreviation of the corresponding mask) will be entered via the Parameters function accessible by right click on the data type of the field associated with miscellaneous table B.
Screen dictionary function