Config. Related Field

Diagrams

Table

Config. Related Field

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	Table ID (Table ID)	Integer
2	Field ID (Field ID)	Integer
3	Field Name (Field Name)	Text30	CalcFormula: Lookup(Field.FieldName WHERE (TableNo=FIELD(Table ID), No.=FIELD(Field ID)));	Editable: No FlowField
4	Field Caption (Field Caption)	Text250	CalcFormula: Lookup(Field."Field Caption" WHERE (TableNo=FIELD(Table ID), No.=FIELD(Field ID)));	Editable: No FlowField
8	Relation Table ID (Relation Table ID)	Integer	TableRelation: AllObjWithCaption."Object ID" WHERE (Object Type=CONST(Table))	Editable: No
9	Relation Table Name (Relation Table Name)	Text250	CalcFormula: Lookup(AllObjWithCaption."Object Name" WHERE (Object Type=CONST(Table), Object ID=FIELD(Relation Table ID)));	Editable: No FlowField

Keys

#	Fields
0	Table ID,Field ID (Table ID,Field ID)		Clustered: Yes
1	Table ID,Relation Table ID (Table ID,Relation Table ID)

Table Relations To Other Tables

Field	Related Table	Related Field
Relation Table ID (Relation Table ID)	AllObjWithCaption	Object ID (Object ID)	TableRelation: AllObjWithCaption."Object ID" WHERE (Object Type=CONST(Table))	1..n

Table Relations From Other Tables

From Table	From Field