Lookup Question

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Lookup Question

Feedback Type: Problem

Product Area: Domino Server

Technical Area: Application Development

Platform: Windows

Release: 8.5.3

Reproducible: Always

I have a slight problem - I loop through a "Orders" view and based on the location from the orders I grab the some data from the "Lookup\Location" view using entry.ColumnValues.
My problem occurs when I have two names that are similar or the first part of the name is similar. For example if in the "orders" view there is "Kansas" and "Kansas City"
and the "Lookup\Locations" only has "Kansas City" it will pull the same data for "Kansas" and "Kansas City".

Set db = session.Currentdatabase
Set view = db.Getview("Orders")
Set doc = view.GetFirstDocument

Do Until doc Is Nothing
location = doc.GetItemValue("Location")(0)
Set teamview = db.Getview("Lookup\Location")
Set entry = teamview.GetEntryByKey(location)

I hoping there is an easy way around this. Any help is greatly appreciated.

Feedback number WEBB9BAGJK created by ~Mark Xanhipipulakol on 09/06/2013

Status: Open
Comments: