Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

auto populate fields with LOV

Status
Not open for further replies.

bookouri

IS-IT--Management
Feb 23, 2000
1,464
US
I have a LOV with ssn, last, first, middle. Normally the user would hit the LOV key and select an SSN and the LOV would populate the ssn, last, first, middle. But I want the user to be able to enter a series of ssn's without seeing the LOV unless they enter an invalid ssn. Now even though the lov is designed to return the values, if the user just enters the ssn and moves on the last, first and middle fields are not populated. How can I have the LOV auto populate the last, first, middle fields automatically when it is not actually called up by the user?

thanks in advance for any suggestions.
 
Try to change Automatic Select LOV property to true.

Regards, Dima
 
I tried that, as best I can tell, it only tells the LOV to autoselect the value once the user has drilled down to one row in the lov. It doesnt seem to have anything to do with autoselecting the other columns.

>>>Specifies what happens when an LOV has been invoked and >>>the user reduces the list to a single choice when using >>>auto-reduction or searching:
>>>n When Automatic Confirm is set to Yes, the LOV is >>>dismissed automatically and column values from the >>>single row are assigned to their corresponding return >>>items.
>>>n When Automatic Confirm is set to No, the LOV >>>remains displayed, giving the operator the option to >>>explicitly select the remaining choice or dismiss the >>>LOV.

In my scenario the LOV select box will never appear unless the user enters an invalid ssn...



 
I had to go into the field and select VALIDATE FROM LIST = Y. This makes the form act like I wanted it to..


thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top