You are viewing limited content. For full access, please sign in.

Question

Question

Is it possible to do a wild card lookup using SQL in Forms

Forms
Updated June 19, 2018
asked on June 19, 2018

Basically what I want to do is be able to do a lookup in Forms using part of a value from SQL. For example...

 

If my table has the values; 123456, 654321, and 789654, I want to be able to type 123* or something similar and still get the results.

0 0

Replies

replied on June 19, 2018

Are you trying to have a sort of autosuggest functionality? In the Forms Designer, under Lookup Rules, you can remove the When condition. For example, if I type "ne", it would suggest Minnesota, New York, and all other values that contain the sequence "ne" anywhere.

If you're looking for something more custom, you can also take a look at the Help Files on Stored Procedures.

1 0
replied on June 19, 2018

What I have set up right now is that when you type in a number related to a client it'll pull all their info (probably about another 30 fields that populate). 

I want to be able to type in just a part of the number and get like the closest match I can get. I would like to apply this to other fields besides the number such as a name field or something. 

Do you think this might be possible with Stored Procedures?

0 0
replied on June 19, 2018

Probably. The query would have to be something like WHERE ClientNumber LIKE '%123%'.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...