Expression help!

[NCD]

I have a 

[Product] Table which contains;

•Product ID

[Size] Table which contains;

•Size ID

•Product column type Ref

[BOM] Table which contains;

•BOM ID

•Product column type Ref 

•Size column type Ref

in my [BOM] Table’s Size column type Ref, I want to write an expression that says,

only show me the sizes that matches this Product ID. So in my drop down menu I won’t see every size of every product.

Tried to figure out myself and didn’t get anywhere close I think…

mine was,

IF(_THISROW =[Product ID], [Size].[Size ID], BLANK)

Can anyone help me out?

[Aurelien · Accepted solution]

Hi @NCD 

What about that in the Data Validity/Valid_If expression of your Size in the table BOM ?

[Product].[Related Sizes]

[NCD]

Thank you, it worked!!