How to Create Relationship on a mac

Does anyone know where the "Create Relationship" option is when using a mac.
I'm using a macbook pro and my Excel version is 16.80.
For context, I want to be able to create a relationship between a column in a table that stores data and another table that translates the key into its actual meaning.

Example:

data table:
dept | employee |  salary
  2     |   Janet.      |  $57,000
  1     |  Brad         |  $67,500

department key table:
number | department
    1        | Accounting
    2        | Sales

I would like to create a relationship between the "dept" column in the first table and the "number" column in the second table. So when I eventually make a pivot table, I would be able to easily summon the actual department name of each employee. Thanks.