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

[Miranda_Lubarsk]

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!