I build HR Solutions and am trying to work out how to create reporting relationships in Airtable.
My usual approach is to have a Employee table and a Jobs table…
Employee links to Jobs via the Job field on Employee
The Jobs table has a self Join via field called Reports to the Manager’s Job
This finally links back to the Employee table again to access the Manager’s information
This then typically allows me to use the macro/calculated field/query features to access an employee’s manager’s details for things like routing approval emails for leave requests.
This seems to fall at the first hurdle in Airtable because Lookup fields don’t seem to know anything about self joins. Is there any way round this because it\s pretty fundamental to most things I do with databases?