Hi I need some help with modeling my app ta...

AppSheet AppSheet Q&A
1

Hi

I need some help with modeling my app tables.

My app track the fulfillment of work orders.

  1. One work order. 2. one\many batches with differing quantity of products. 3. each batch takes several steps in different stations to complete the batch.

what tables should i create and what should be the dependencies?

Thanks for the help

2

You need related table structure where the Order is the parent and batches child records. Please check this article… help.appsheet.com - References Between Tables References Between Tables help.appsheet.com