Author Topic: DBLookup Doesnt Work  (Read 1132 times)

0 Members and 1 Guest are viewing this topic.

Offline CyborgRepublic

  • Full Member
  • *
  • Posts: 202
  • Karma: +0/-0
    • View Profile
DBLookup Doesnt Work
« on: November 27, 2008, 02:19:01 AM »
Hi!

Sorry about this one, but I\'m not able to make dblookup work. I found many examples on the forum, but when I try to convert it to my reality, it doesn\'t work...

The steps that I did are:

I created a form (fCountry) so the users can store the country name (txtCountryName) and its acronym (txtCountryAcron).

Then I created a view (vCountry) with two columns: txtCountryName and txtCountryAcron. I\'m using SELECT Form = "fCountry" in view View Selection.

Everything seems to be working fine. I\'m able to create a new document, and after that it\'s shown into the view.

So I created a new form (fProduct) and put a field called (cbxCountry). Insied field\'s control tab, in Choices, I selected "Use formula for choices", and used the following formula:

@DbLookup("":"NoCache";"":"";"vCountry";txtCountryName; 1);

I tried many other parameter combinations, with no lucky. I always get "entry not found...".

What I doing wrong?

Techronnati | where technology never sleeps

DBLookup Doesnt Work
« on: November 27, 2008, 02:19:01 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
201 Views
Last post November 11, 2008, 11:47:55 PM
by nrvz
0 Replies
43 Views
Last post March 03, 2015, 06:47:28 AM
by JusticeLeague

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.