How to display names from directory that are not listed in another view?

Hi there!

I have a requirement that if one person is assigned to a project, their names disappear from the list of people that are available. I have a form with a combobox displaying all employee names from names.nsf. When I assign a person to a project, that person’s name must disappear from the combobox.

Can’t figure this one out!

Any help would be appreciated.

Thanks!

Gérald

Subject: Got it!

Here’s the code I used in my combobox:

“”:@Sort(@Trim(@Text(@Replace(@DbColumn(“”:“NoCache”;“”:“names.nsf”;“EmployeeID”;2);@DbColumn(“”:“NoCache”;@DbName;“ItemAdministratorsView”;2);“”))))

Works well.

Gérald

Subject: Then you will not need this:-)