Dblookup problem

HCL Domino Domino Forum
1

I am trying to design a page that will have three elements:

  1. A Combobox to select the field StateFinder. No problem, just used a keyword list with all the states.

  2. A Combobox field that will list all cities in that state that are in our client database.

  3. A view within the form that will list each client in that city.

For No. 2, how do you do a lookup that will prevent duplicate cities? IOW, I may have 20 clients in Atlanta but I only want the city to appear once in the box.

No. 3 should take care of itself with a lookup based on the first two fields.

Any help for a fumbling Notes manager very welcome!

Mark

2

Subject: Dblookup problem

Mark,

For the second one, just add @Unique before your @dblookup(…

HTH

Mike

3

Subject: RE: Dblookup problem

Thanks so much! Worked like a charm.

Speedy responses around here, lol.

Mark