• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

DBLookup Failure

I continue to struggle with @DBLookups. Have form which has a subform which has a number of contact by business line. I have a form that has all the contact and am not able to get it to pull the value. Field is a computed names field. poc is the view, agency_num is the field that it looks to which is on the same form that the field are embedded into. Trying to pull the value from column 2. What am I missing here.
@DbLookup("": "NoCache";"";"poc";"agency_num";2;[FailSilent])

Open in new window

  • 2
1 Solution
In the view "poc", make sure the first column is sorted.
Also, I suggest to use below and see what error it populates.
@DbLookup("": "NoCache";"";"poc";"agency_num";2)
Once the above is successfull, then u can use your code or a combination of @ISError
You're now lookup for a value "agency_num"; NOT is value!
Try again after removing the quotes around the fieldname.
jforget1Author Commented:
Appreciate the help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now