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?
Solved! Go to Solution.
Hi @NCD
What about that in the Data Validity/Valid_If expression of your Size in the table BOM ?
[Product].[Related Sizes]
Hi @NCD
What about that in the Data Validity/Valid_If expression of your Size in the table BOM ?
[Product].[Related Sizes]
Thank you, it worked!!
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |