Diagrams


Table

User Group Member

Fields

# Name Type
1 User Group Code (User Group Code) Code20 NotBlank: Yes
2 User Security ID (User Security ID) GUID
3 Company Name (Company Name) Text30
4 User Name (User Name) Code50 Editable: No
FlowField
5 User Full Name (User Full Name) Text80 Editable: No
FlowField
6 User Group Name (User Group Name) Text50 Editable: No
FlowField

Keys

# Fields
0 User Group Code,User Security ID,Company Name (User Group Code,User Security ID,Company Name) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Company Name (Company Name) Company Name (Name) 1..n
User Security ID (User Security ID) User User Security ID (User Security ID) 1..n
User Group Code (User Group Code) User Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field