Diagrams


Table

Item Tracking Comment

Fields

# Name Type
1 Type Option
2 Item No. Code20 NotBlank: Yes
3 Variant Code Code10
4 Serial/Lot No. Code20 NotBlank: Yes
5 Line No. Integer
11 Date Date
13 Comment Text80

Keys

# Fields
0 Type,Item No.,Variant Code,Serial/Lot No.,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Variant Code Item Variant Code 1..n

Table Relations From Other Tables

From Table From Field