I want to track Companies, People, and date each person is hired.
In a relational database I would use a “join table” to handle the many-to-many relationship and would include a “HiredDate” field in this join table.
AirTable makes many-to-many relationships easy, but then no easy way to track hire date for each person at each company. This seems like such a common use case (companies/people, products/customers, students/classes). What am I missing?