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.