Hi,

I am trying to make a simple tool for my warehouse to check item availability for ordered goods.

The idea is to made an "entry data form" which content "order date" "order number" and "customer name", and another form "ordered item" as a subform which content a spreadsheet element which will content "item name","ordered qty", "ready qty", "indent qty".

On "entry data form", the operator will entry the "order number" and "customer name", as well as filling "item name" and "ordered qty". My plan was to save the "order number" and "customer name" on a datalist (orderDataList), and the "item name", "ordered qty","ready qty" and "indent qty" on another datalist (eg itemDataList)

The warehouse will then using another form to retrieve all the item on itemDataList to edit the "ready qty" and "indent qty". If the Indent qty=0 then the warehouse will made a shipping record with another form "shipping Form" which will consist of shipping data "shipping date" "courier name", with form "ordered item" as its subform which contains spreadsheet (just like the "entry data form")

Is there any guidance how to work with spreadsheet element on this scenario, as well as how to link each line in spreadsheet to the "order number" so it can be filtered according to the order number, for the warehouse to see the "ordered item" according to the order number?

I have see the demo for Expense Claim Apps which use spreadsheet, but in that sample the spreadsheet data is not saved on datalist.

TIA

Dhany