View Selection Formula

Hello

I am wondering if the following is possible.

I have a form (named "form) which has multiple fields. e.g. Name, First Name, City, Phonenumber

Now I would like to make selection formula for a view based upon the uniqueness of “name, first name, city”.

name_sel := name;

fname_sel := fname;

city_sel := city;

SELECT ((Form = “form”) & (@Unique(name_sel + ", " + fname_sel + ", " + city_sel))

If John Doe from Los Angeles would have multiple phone numbers stored in a separate document then he should appear only once in the view.

Is that possible?

Subject: View Selection Formula

Dont change anything in selection formula. Create a view with first column as name, then first name, city adn phone number. In view properties second last tab, check the option : “generate uniques keys in index”. Now see if you get the desired result.

Regards

Rosie

Subject: RE: View Selection Formula

Dear Rosie

That is for ODBC access and I need to create dblookups in the same database and then I just don’t need to have two documents being retrieved by the lookup. That’s the problem I have.

Subject: RE: View Selection Formula

While that option was created for ODBC access, it should provide the same result in a pure Notes environment.

Subject: RE: View Selection Formula

We use it all the time for getting unique values in dblookups.

Try it out…

Subject: View Selection Formula

Sorry, but no - The SELECT formula is run on each document independently. You cannot select documents for a view based on other documents.