How to Reference Multiple Inventory Tables in a Form

AppSheet AppSheet Q&A
1

Hi

I have different Inventories which specifications headers are different to each other. so I have each inventory category list as separate list/table. Now when I Make Purchase order or sales how can I reference the Inventory list in the form which could enable me to access all my different inventory tables? in the form it allows only one table to select. Is there any way to do this?

2

I suggest you to check if it’s really needed to have multiple tables for the same entity

App design 101 - AppSheet Help
3 Likes
3

Slices: The Essentials - AppSheet Help

2 Likes
4

A form can only be based on one table. Seems like waht you’re trying to do is a parent-chd setup which will give you one order->multiple inventory items.

You really need to check out what SkrOYC suggested.