Ref 3 tables

[jcmoras]

I have 3 tables, PRODUCT, MODEL AND PRICE.

When I add a new PRODUCT , I choose a MODEL with a dropdown list and I want to automatically get the value of that model, from PRICE table. ( I make it work but I have to select the same MODEL in two dropdown list every time  I add a PRODUCT)

MODEL and PRICE, share the same ID, every MODEL was one Value ( PRICE)

 

[AleksiAlkio]

Why do you need the Price table if IDs are the same than in Model table, meaning.. you have only one value for one model? Why don't you have the price in Model table?

[jcmoras]

Model table is also using in other app, for productions purposes , so I need to have two  tables. 

[AleksiAlkio]

Hide that field in this other app so you don't need an extra table, possible?

[jcmoras]

no , model table es directly updated from the googlesheets file , so i can hide any field

[AleksiAlkio]

Read the value with an app forula like.. [Model].[Value].[Value]