Imagine this scenario - I want to create an invoice line. I have a product table of product_code and sales_price. I have the product code and quantity in the invoice line table and want to lookup the sales_price and copy it into the invoice line table field sold_price_each. I can do it with a lookup but that has a problem. If the price of the item changes in future, then the invoice will change after it’s been issued, which is no good at all!
I am new to Airtable and cant see a way forward on this one. Any help appreciated.