Diagrams


Table

Standard Address

Fields

# Name Type
1 Related RecordID (Related RecordID) RecordID
2 Address Type (Address Type) Option
3 Address (Address) Text50
4 Address 2 (Address 2) Text50
5 City (City) Text30
6 Country/Region Code (Country/Region Code) Code10
7 Post Code (Post Code) Code20
8 County (County) Text30

Keys

# Fields
0 Related RecordID (Related RecordID) 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