Applying a Price from another table

[djbginns]

Hi,

I'm looking for the expression to look up a price from another table that matches the product in the form that would be a REF in the same table.

Thanks,

Brendan 

[dbaum]

It's hard to provide confident guidance without more information regarding your tables and columns, but here are a couple potential approaches.

[Product ID].[Price]

INDEX(SELECT(Products[Price], [Product ID] = [_THISROW].[Product ID]), 1)

[djbginns]

Thanks for the quick response.

Table 1: Bottle Inventory_Powerhouse Ibiza (Source)

Table2: Bottle Sales 

REF: Bottle ID to Bottle Type 

 Select goal : Price Per Unit (Bottle Inventory_Powerhouse Ibiza) -- > Cost (Bottle Sales )

The goal is to carry the price that matches the bottle type from the database into the sales form.

[djbginns]

I just tried it with your formula! it worked great thank you so much!