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>
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