Adding a new column without actually making the column in google sheet

AppSheet AppSheet Q&A
1

I am making a product order app. So I have a customer table the an order table then a product table.

Basically what i want to do is under one customer I can have multiple orders and under one order I want to have multiple products.

I am able to do the first one having multiple orders under on customer but, not able to have multiple products under one order.

can someone help

2

Assuming the product table is called PRODUCT, the simply having a column in the Order table called [PRODUCT] should create the reference

1 Like