Diagrams


Table

Item Vendor

Fields

# Name Type
1 Item No. Code20 NotBlank: Yes
2 Vendor No. Code20 NotBlank: Yes
6 Lead Time Calculation DateFormula
7 Vendor Item No. Text20
5700 Variant Code Code10

Keys

# Fields
0 Vendor No.,Item No.,Variant Code Clustered: Yes
1 Item No.,Variant Code,Vendor No.
2 Vendor No.,Vendor Item No.

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field