Re: Forms 4.5 Pop-list question

From: <Dan>
Date: 1997/10/07
Message-ID: <61db2g$cle_at_drn.zippo.com>#1/1


In article <615ep7$3rd_at_eng-ser1.erg.cuhk.edu.hk>, kkkong_at_ee.cuhk.hk says...
>
>I have just done this recently. What I did was:
> 1) Create a separate text item which was the poplist;
> 2) This poplist did not belong to any database table;
> 3) In the query for the poplist, I had "Select to_char(emp_id), name
> .......",this gave me the emp_id as char;
> 4) Then I created a "When-validate-item" trigger to copy the
> to_number(emp_id) to the emp_id from the database
>
FYI, we've been doing the same thing with bast table text item poplists, and it works great. That way you don't need to have the 'when-validate-item' trigger at all.

Dan Peacock
Systems Engineer
Great Lakes Hybrids, Inc. Received on Tue Oct 07 1997 - 00:00:00 CEST

Original text of this message