Hello @mailyarrum, they way I do that is having a parent table named “Orders” with all the information related to a single purchase order, then there’s the “Products” table, or in your case it shall be “Parts” table, it is the child table of the “Orders”.
The idea is to create a new Order, and then use the “Related Parts” virtual column that is automatically created by appsheet after the reference is set up.
That allows you to add parts to your order directly from the “Orders” form using the “New” or “Add” button that comes with it by default, that button will take you to the form view for adding a new row in your “Parts” table, there you will select a single part and it’s desired quantity, and repeat this process for each different part that you wish to add to your order.
There might be other ways to do this, but this is the one I found easier hehe, but for this you must be quite familiar with references and how they work:
LinkedIn
Twitter
