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