Lookup is a type of control that enables the user to define a 'to-one' relationship.
There are two types of Lookup fields, defined in RELATIONSHIP TYPE tab:
- Many to One
- One to One
Ownership Properties
Ownership can also be defined on Lookups, there are two types:
- No Ownership
- Full Ownership
Type | Ownership | Description | Example |
|---|---|---|---|
| Many to One | No Ownership | A normal lookup. Points to a single resource, but neither is owned by the other | Employee is in Department |
| Many to One | Full ownership | This resource is owned by the resource being pointed to | Plan Step belongs to Plan |
| One to One | No Ownership | A normal lookup. Points to a single resource, but neither is owned by the other | Car has Engine |
| One to One | Full Ownership | This resource is owned by the resource being pointed to | Each Student has a User Account |