I’m wondering if it’s possible to have a multi-item order record and deduct from our inventory table without having to enter each item in the unique orders as a separate record.
For example, if Stefani places an order as order number 100 for 2 chicken breasts, 3 racks of lamb, and 1 whole chicken (we are a butcher shop), I am currently entering order 100 three times, as three separate records, so that I can use a quantity field to deduct from our inventory table. Is there a way to have Stefani’s order under 1 record, and still have each of those items/quantities deducted from our product inventory?
Thanks! I’m new to Airtable so sorry if I didn’t explain well.