Diagrams


Table

Family Line

Fields

# Name Type
1 Family No. Code20 NotBlank: Yes
2 Line No. Integer
8 Item No. Code20 NotBlank: Yes
10 Description Text50
11 Description 2 Text50
12 Unit of Measure Code Code10
20 Quantity Decimal (0:5)
25 Low-Level Code Integer

Keys

# Fields
0 Family No.,Line No. Clustered: Yes
1 Low-Level Code

Table Relations To Other Tables

Field Related Table Related Field
Family No. Family No. 1..n
Item No. Item No. 1..n
Unit of Measure Code Item Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field