Forms master-detail synchronisation - with a twist

From: <KJOHNSON_at_ESRIN.BITNET>
Date: Fri, 5 Aug 1994 10:34:41 CET
Message-ID: <94217.103441KJOHNSON_at_ESRIN.BITNET>


Imagine the scenario as follows :

   master block - departments
   detail block - employees

You can 'default' the department block, then default the 'employee' block (using constraints) and Forms builds the triggers to synchronise the blocks : i.e. the employees are queried for the department selected.

However, you can only select one department at a time.

Can anyone recommend a technique whereby you can select multiple departments and then display all employees within the selected departments !!!

Ý Is this in the ORACLE documentation or an FAQ - if not, I can   summarise the responses and our experiences of implementing. ¨

Thank you in anticipation, Kevin.


Kevin Johnson                      EMAIL  :  johnson_at_mail.esrin.esa.it
Information Administrator
European Space Agency              DISCLAIMER :  These views are mine
ESRIN, FRASCATI, ITALIA.                         not necessarily those
                                                 of my employer.
Received on Fri Aug 05 1994 - 11:34:41 CEST

Original text of this message