Specify number of each linked record on airtable

[Luyz]

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

[Adam_TheTimeSav]

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!