Anyone know how to disassociate a de-ref?
I have two columns in a form.
One is a ref to [Plant ID].
The other is a ref to [Tray Size] from the same referenced table as the Plant ID.
However, I do NOT want it to form a de-ref, I want a drop-down menu of ALL the values in the column [Tray Size], not just the ones associated with whatever I select in the Plant ID column.
Is this possible?
Is there a work-around?
Thanks!
Set the Valid_If for [Tray Size] to =MyTable[Tray Size] (replacing MyTable with the appropriate table name). If that doesnโt work, try =filter(MyTable, true) instead.
@Steven_Coile didnt work, because the column I want isnt the key and it didnt accept a tack-on of the column.
But I just added another table woth separate tray sizes attached to form a work around.
Not happy about it though bc that means I will need to update pricing in 2 places now.
In Valid_IF, Select(plant[Tray],true) will get a drop-down and not dependent dropdown ,and no need for de ref. The true parameter actually picks all values in Tray column.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |