One Value in two different tables

Hello Appsheet friends,

Iยดm having trouble mixing values on two different tables. 
Products_List table (with 2 columns: Products_ID and Products_Name) and Mix_ Library table (with also two columns: Mix_ID and Mix_Name). They are independent, as one is my products list (enables me to add new products) and the other the Mix Library (which enables me to create new mix products, that are composed of several Products).

I want the Mix product to be included in the products list too. Any change regarding Mixes will be shown on the products list among the other products as well. Is this possible?
Hope Iยดve been clear enough for you guys to help me out. Thanks in advance. Pedro

0 3 83
3 REPLIES 3

I suggest merging your 2 Tables into 1 Table, with all of the necessary columns from each, along with an additional [type] specification column to indicate whether it is a mix or not.

Hey Marc,

Thanks a million for your prompt reply. 
Your suggestion makes total sense, but both will have different setups to be made as shownprint1.pngw

So?

Top Labels in this Space