Diagrams


Table

Alternative Address

Fields

# Name Type
1 Employee No. Code20 NotBlank: Yes
2 Code Code10 NotBlank: Yes
3 Name Text50
4 Name 2 Text50
5 Address Text50
6 Address 2 Text50
7 City Text30
8 Post Code Code20
9 County Text30
10 Phone No. Text30 [Phone No.]
11 Fax No. Text30
12 E-Mail Text80 [E-Mail]
13 Comment Boolean Editable: No
FlowField
14 Country/Region Code Code10

Keys

# Fields
0 Employee No.,Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code Country/Region Code 1..n
Employee No. Employee No. 1..n

Table Relations From Other Tables

From Table From Field
Employee Alt. Address Code 1..n
Human Resource Comment Line Alternative Address Code 1..n