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

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

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

1 Like