Lookup

Lookup

Example organization structure

Consider an organization with

• 5 departments (company departments), each department has a team name & associated team code. Each Team has many Employees - relationship has been defined using LinkToAnotherRecord 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

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

Additional notes

• Nested 'Lookup' supported: a Lookup field can have its child column datatype as Lookup (or Rollup).