Reference between tables (Product x Customer)

Hi folks.
I’m new in Appsheet.

I’m having difficulties relating the product and customer tables. Each product has a unique id and I want to list many products for each unique customer.

Table Product (Keg)
1_RowNumber
2 id_keg (key & label)
3 keg volume
4 Status
5 Location

Table Customer
1_RowNumber
2 id_customer (key)
3 Name (label)
4 Phone
5 City
6 Address

How to reference and see the related products in customer in line view? In this way can be possible check how many products per id are allocated to Customers.

I’d like your help.

0 3 179
3 REPLIES 3
Top Labels in this Space