Re: Designer Forms: Linking update module component / stand-alone list of values
Date: 9 Dec 2003 08:16:14 -0800
Message-ID: <7ce65461.0312090816.25dd6fb6_at_posting.google.com>
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