Forms 4.5 LOV Questions.
From: Cleve <cleve_at_cbcsf.org>
Date: 1997/04/24
Message-ID: <01bc50d3$51184d80$6b6482d0_at_cbcsf1.techlink.net>#1/1
Date: 1997/04/24
Message-ID: <01bc50d3$51184d80$6b6482d0_at_cbcsf1.techlink.net>#1/1
[Quoted] Hi everyone. I am posting this question hoping that some expert(s) knows a work-around...
Here's my situation:
I have a LOV called EMP (having LastName,FirstName,EmpID) attached to a Manager_ID field. I have set the LastName in the LOV as the first field so that all incremental searches will be on the Lastname. When a selection is made, EmpID is returned to Manager_ID. I need answers to the following: 1. If I type in a # for the Manager_ID and then 'pull up' the LOV, how can I get the associating record in the LOV to be highlighted without narrowing the search? By default, Forms highlights the very first record in the LOV. [Quoted] 2. If I set the 'Validate from LOV' property to TRUE on the Manager_ID field, how can I get forms to validate the Manager_ID field with the Emp_ID column? Because the LastName column is the first in the LOV, Forms, by default, attempts to validate it against this field.
Thanks in advance.
Cleve. Received on Thu Apr 24 1997 - 00:00:00 CEST