Hi Guys,

I have a tree view / subform that associates products to a form in a tree view.  However I want to enforce that only unique products be added.  Therefore I am wondering if anybody has suggestions on how to limit the product dropdown list to limit the results of products to only products not already added to the same tree view.

Therefore if I have "product a", "product b", "product c",  If I already have "product a" and "product b" on the tree view form, when I click add new, it should only be presenting me with one record to select from "product c".

Any way of doing this?

Thanks,
Damien