Anyone know how to disassociate a de-ref? I ...

references
(Miranda Lubarsky) #1

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!

(Steven Coile) #2

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.

(Miranda Lubarsky) #3

@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.

(Thomas Varghese) #4

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.