Specify number of each linked record on airtable
Hello, so ive been doing this inventory app for my company and kinda hit a roadblock, so ive created a sales table where a sales record is created with a date, order no., products, price of each product, quantity, discount and a total but what i want to accomplish is that when i put multiple items into a single sales record like in the last record in this screenshot
i want to be able to put how many of each product in that sales record were sold so that the total comes out to be the correct amount
Hi @Luyz, to achieve this you’re going to need a table for line items I’m afraid. I’ve put an example together here
You’d have a Products table with product information, including the price:
A Line Items table where you would put in the Quantity sold where each record was linked to a Product
And a Sales table where each sale can be linked to multiple Line Items:
This would allow you to set the quantity per product and get the correct total!
