Example organization structure
Consider an organization with
5 departments (company departments), each department has a team name & associated team code. Each
Employees- relationship has been defined using
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
1. Add new column : Click on '+' icon to the left of column headers in Employee table
2. Feed column name
3. Select column type as 'Lookup'
4. Choose child table
5. Select child column
6. Click on 'Save'
Required information is now populated in the newly created column
- Nested 'Lookup' supported: a Lookup field can have its child column datatype as Lookup (or Rollup).