Diagrams


Table

Dimension Value Combination

Fields

# Name Type
1 Dimension 1 Code (Dimension 1 Code) Code20 NotBlank: Yes
2 Dimension 1 Value Code (Dimension 1 Value Code) Code20 NotBlank: Yes
3 Dimension 2 Code (Dimension 2 Code) Code20 NotBlank: Yes
4 Dimension 2 Value Code (Dimension 2 Value Code) Code20 NotBlank: Yes

Keys

# Fields
0 Dimension 1 Code,Dimension 1 Value Code,Dimension 2 Code,Dimension 2 Value Code (Dimension 1 Code,Dimension 1 Value Code,Dimension 2 Code,Dimension 2 Value Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Dimension 2 Code (Dimension 2 Code) Dimension Code (Code) 1..n
Dimension 2 Value Code (Dimension 2 Value Code) Dimension Value Code (Code) 1..n

Table Relations From Other Tables

From Table From Field