Hello @Scott_Noll!

It is possible to manage an inventory in Airtable using multiple tables. The usual workflow for this kind of situation would be to have a table for each product, client, and sales order (as a many-to-many relationships / junction table). You could track each sales order date fields and the number fields can track how much is due for each sales order.

I recommend checking out our Inventory Tracking Template as an example for an Inventory management workflow in Airtable.

Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution .