I need to get the price from another table and bring it to my booking table. The conditions must be based on the company and the route to bring the correct sale price registered in the Routes Price table,
My airtable system is already working and I use the Company field as a lookup for the Customers table and the Routes field is just a single select.
However, today, to form the sales price, I use the supplier's cost price, but this needs to be changed and the sales price needs to be added manually in another table to later appear. If customer is A and route is A show this price If the customer is B and the route is A show this price.
