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

[Camiel]

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.

[M Hamilton]

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.************@minlnv.nl (Camiel) wrote in message news:<da**************************@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.