Diagrams


Fields

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

Keys

# Fields
0 Code (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

Table Relations From Other Tables

From Table From Field
Employee Union Code (Union Code) 1..n