Re: validate from list?

idranoel wrote:

> I have in form a data(not DB) from a lov with a validate from
> list....for the zip code....this code is not the primary key from
> table city.
> it's good...when the client insert the zip code and it's are more with
> the same code, will appear the lov....
> the problem is when I load a client int the post-query trigger I try
> to take the zip code and insert him in the field...but if there are
> more with the same code...it will appear the lov....
> I would like that the lov appear when the client insert the zip, but
> not when I inswert it from pl/sql (post-query trigger)....
> I try to set from plSQL the validate from list to false and then
> insert the zip code... and after reset it to true....but the problem
> is there too....
> any suggestion?
> thanks

[Quoted] How can you possibly have a table with zip codes and not have the zip codes as the PK? In the U.S. there can legally only be one city per zip code ... at least according to the USPO.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)