Home -> Usenet -> comp.databases.oracle -> Designer Forms: Linking update module component / stand-alone list of values

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

From: Camiel <c.vanderhoeven_at_minlnv.nl>
Date: 5 Dec 2003 02:57:07 -0800
Message-ID: <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 Fri Dec 05 2003 - 11:57:07 CET












Original text of this message