Can I group by a column in a linked table?

[Michael_DelGaud]

I have three tables:

Employee

• name
• linked column to their position

Positions

• name
• linked column to the department its in

Departments

• name

Is there a way to create a grid view that groups the employees by departments?

So it would look something like this:

Sales
    Alice | Salesperson
    Bob | Salesperson
   Carla | Coordinator
Accounting
   Angela | Accountant
   Brett | Accounts Payable
   Caspar | Accounts Receivable

[Michael_DelGaud]

I figured it out. For posterity and anyone else who might need it:

The way I solved it was to create a lookup field in the employee table that looked up the department in the linked positions table. This created a column directly in the employee that I could then use for grouping.

This is the help article I used for lookup fields

[Elias_Gomez_Sai]

That is the way and what Lookup fields are for :winking_face: