Diagrams


Table

My Job

Fields

# Name Type
1 User ID (User ID) Code50
2 Job No. (Job No.) Code20 NotBlank: Yes
3 Exclude from Business Chart (Exclude from Business Chart) Boolean
4 Description (Description) Text50
5 Status (Status) Option
6 Bill-to Name (Bill-to Name) Text50
7 Percent Completed (Percent Completed) Decimal
8 Percent Invoiced (Percent Invoiced) Decimal

Keys

# Fields
0 User ID,Job No. (User ID,Job No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Job No. (Job No.) Job No. (No.) 1..n

Table Relations From Other Tables

From Table From Field