Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Lookup formula issues.

Posted on 2010-01-12
Medium Priority
Last Modified: 2013-12-18
Have a form which has a subform for points of contact for various depts. There are about 15 computed fields which initially worked perfect. Because they might need to reassign these to another user due to vacation they needed to be editable. When I changed them over to editable only one of the fields pulled in the name properly. The rest get no data at all. I have checked the field properties and they are identical. What would make one formula to work when none of the others get any data.   Any ideas?

This formula is working  @DbLookup("": "NoCache";"";"poc";agency_num;2;[FailSilent])
This formula is not working  @DbLookup("": "NoCache";"";"poc";agency_num;3;[FailSilent])

Question by:jforget1
LVL 46

Accepted Solution

Sjef Bosman earned 1000 total points
ID: 26299003
Would the formerly computed fields perhaps have an Evaluation or Validation formula that is incorrect?

Suggesting the following change, for debugging purposes only:

      @Prompt([OK]; "agency_num"; agency_num);
      x:= @DbLookup("": "NoCache";"";"poc";agency_num;3)
      @Prompt([OK]; "x"; x);

The view poc, is it sorted, and is agency_num indeed an index in that view? If agency_num is numeric, is the first column in the view also numeric? Always?
LVL 19

Assisted Solution

madheeswar earned 1000 total points
ID: 26299782
If my understanding is right, you changed the Computed fields to Editable. If it is the case then, the DBLookup won't work for editable fields. You need to make the editable fields as Dialoglist/checbox/radiobutton type. Else, display a picklist (use @Picklist) and from the selection of the document in the picklist, you can capture other values to the editable fields.
Alternatively, you can use Lotus Script as well.

Author Comment

ID: 26303960
Figured this one out, was pulling the values from a PickList. I had rem'ed some of those out. I am just going to add the code to pull all, the values to this code.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Integration Management Part 2
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question