Diagrams


Table

Alternative Address

Fields

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

Keys

# Fields
0 Employee No.,Code (Employee No.,Code) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

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