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

Question

Question

Display Returned Result without Auto filling

Forms
Updated August 4, 2017
asked on August 3, 2017

Hi All,

 

I have created a work order form which has a required field for the work order number.

 

The field "Work Order Number" (Currently a Single Line Field - This is to allow new work order numbers to be entered, as well as old numbers to be selected) is set to pull back information from a database to display a list of Work Order Numbers that apply to the currently select Property Address. This is to allow the customer to view all previous Work Order Numbers relating to the selected Property. 

 

The issue I currently have, is that if the Property only has had 1 previous Work Order, this field is auto-populated on the form, which will cause a ripple effect of errors to occur if gone unnoticed. 

 

My question is, when using Lookup Rules, to display a list of results, is it possible to only display the result in a drop down box without auto filling the field? (Works perfectly when more than 1 result is found)

 

Thanks all.

0 0

Replies

replied on August 4, 2017

I am not sure but something I have done in the past is to write a stored procedure so that there is always an additional item in the list.  Instead of a straight up query, write a stored proc that does the same thing but also adds something to the list.  Something like 

SELECT lastname from tEmployee UNION SELECT '(Plese pick one)'

If you run this you will get a query return of last names with the Please pick one at the top:

(Please pick one)

Anderson

Johnson

etc.

You would still pass in your parameter but even if that parameter finds one result it will always display the "please pick one".

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

Sign in to reply to this post.

Details
Related Posts
Loading ...