Hi. I'm creating an app for my store which wo...

(Kranthi Kumar) #1

Hi. I’m creating an app for my store which would keep track of my sales and stock levels. At the moment, I’m using it to scan the barcode to add and sell stock and would like help with the following if possible.

I’ve a spreadsheet with a list of handsets and SIMs. Whenever a sale is added, the device/SIM gets a sale date. However, if a customer opts to purchase both handset and a SIM, you would have to run the sale form twice while repeatitevely typing customer details. Is there a way so that the form gives me an option like SIM attached? and when I select it it takes me to a form within this form and helps me scan the second item?

Apologies if its not clear.

(Aleksi Alkio) #2

You could use related table structure where the SIM will be the child record for your parent record (Sales). Please check this article… help.appsheet.com - References Between Tables References Between Tables help.appsheet.com