I use a spreadsheet that has a number of sheets per day for listing sales/orders. The order pickers use this printout to collect and distribute the orders.
Each sale/order has a buyer, and a number of lines of purchases (qty, product, price).
Using the Numbers App for iPad, can I create a Form that will fill out these details and then update the Table so that I can show a multiple number of sales (buyers and his purchases) per sheet?
The trouble I am having is to create the multiple purchases for each buyer.
I have only been able to create the form with a buyer and 1 purchase.
The general layout on the sheet that gets printed by the order pickers would be like this:
Buyer 26 Product $25 52 Product 2 $50 Buyer 2 2 Product 3 $10 150 Product 4 $1
The "Form" the salesman fills out while talking to the buyer should just be the buyer and his multiple purchases and this will then update onto the table/sheet above.
I hope I am clear enough. I have only had the App a few days. Thanks for any help.