Re: Designer Forms: Linking update module component / stand-alone list of values

Camiel,
I had a similar form created in Designer6i. I let the user choose what year they were interested in from a drop down LOV. Then the Account values displayed to the user to choose from were based upon the LOV year selected. To accomplish this you will need to put the code in your 'validation where clause' at the table level of your List of Values for your Module.

If I need to give you more details, just let me know.

Maggie

c.vanderhoeven_at_minlnv.nl (Camiel) wrote in message news:<da6644a4.0312050257.61718adf_at_posting.google.com>...
> Hi,
>
> I'm trying to do the following:
>
> create a form, with at the top a list of values drop-down box, filled
> with values from table A.
> Also at the top, an input box to enter a year.
>
> Below that a list, allowing updates and inserts on table B, where
> B.year = the entered year, and B.A = the record selected from table A
> (foreign key relationship is defined on the database). The list should
> only show the records that fit these criteria, and if a user inserts a
> record, it should set these fields to these criteria.
>
> Now, how do I do that in Designer 6i?
>
> Any help would be greatly appreciated!
>
> Thanks,
>
> Camiel.
Received on Tue Dec 09 2003 - 17:16:14 CET