Diagrams


Table

Maintenance Registration

Fields

# Name Type
1 FA No. Code20 NotBlank: Yes
2 Line No. Integer
3 Service Date Date
4 Maintenance Vendor No. Code20
5 Comment Text50
6 Service Agent Name Text30
7 Service Agent Phone No. Text30 [Phone No.]
8 Service Agent Mobile Phone Text30 [Phone No.]

Keys

# Fields
0 FA No.,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
FA No. Fixed Asset No. 1..n
Maintenance Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field