Lookup
Example organization structure
Consider an organization with
- 5 departments (company departments), each department has a team name & associated team code. Each
Team
has manyEmployees
- relationship has been defined usingLinkToAnotherRecord
orLinks
column - 5 employees working at different departments
Now, let's explore procedure to retrieve team-code information in Employee table using LOOKUP columns
Configuring a lookup column
- Add new column : Click on '+' icon to the left of column headers in Employee table
- Feed column name
- Select column type as 'Lookup'
- Choose child table
- Select child column
- Click on 'Save'
Required information is now populated in the newly created column
Additional notes
- Nested 'Lookup' supported: a Lookup field can have its child column datatype as Lookup (or Rollup).