Looking for some help.
We work with employers to provide company cars as an employee benefit.
- For each employer there are multiple employees
- For each employee there can be multiple cars
- For each car we charge a series of monthly payments
I’m trying to setup AirTable so that when I select an employer and month, I can output an invoice with the relevant monthly payments.
I’ve done the first steps:
Set up an employers table that links multiple employees per employer
Set up an employees table that links multiple cars per employee
Set up a monthly payments table that links cars to a series of payments by month
I’m struggling with the final step where I want to set the employer and month and output the total payments, so that I can create an invoice. Any advice would be appreciated.