I'm trying to create a sotre management system. I have a table with the ID of the product, name of the product, category, price, etc. I need to linked to a new table wich will be the sales screen in the app. I havent being avle to link the price data cell to the ID piklist on the new table.
Enter this into the [Precio] column of table A_...
=[ID][Precio]
I think this is what you're looking for? Referencing =[ID] returns a specific row from table B_, and then [Precio] should get you the value from that row.
to pull the Precio column from the Rowlink defined in the ID column. There is no need for a FILTER expression - since you already have the unique row identified by the Rowlink in the ID column. In fact, FILTER returns a set (or array) - and you are actually interested in a specific value, so FILTER will not work in this example anyway.
You can go one step further - you do not need to even save the Precio in a column in the A... table. You can simply use the following formula in the Total column instead: