Re: Displaying Selection

Neil Johnson wrote:
>
> Here's a question:
>
> I have form where the user looks up info by serial numbers.
>
> Unfortunately, there can be duplicate serial numbers, so I have a
> primary key consisting of the serial number and the ship date
> of the item.
>
> When the user enters just a serial number, I want to check and
> see if there is more than one serial number. If there is, I want
> to display a list of serial numbers and ship dates (from one table) and
> the some customer information (from another table) so that user
> can pick the specific serial number record they want to look at.
>
> I tried setting up a separate block and use the WHEN-VALIDATE-ITEM
> procedure, but you can't navigate to a another block in a
> WHEN-VALIDATE-ITEM Trigger.
>
> What can I do ?
>
> --
> Neil Johnson - Motorola - Neil_Johnson-CNJ002_at_email.mot.com

You can do the validation using a cursor, then displaying the list through a List of Values(LOV), if I understood the problem correctly.

Sridhar. Received on Fri Feb 14 1997 - 00:00:00 CET