By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,312 Members | 1,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,312 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.