Re: (Q)DES2K-Generator for Forms

David,

Just enter the following statement in the Default Where Clause of the detail :

 detail_block_field in

 	select (table_value
 	from table
 	where lookup_value = :MASTER_BLOCK.MASTER_BLOCK_FIELD)

So, it is possibel to reference form fields in your default where. At generation time you'll get a warning, but it works! (At least, in Des2k 1.2a it worked...)

Roel.

David J. Roth <droth_at_sii.com> wrote in article <01bbc744$4eb048e0$8b0ebe9b_at_droth.sii.com>...
> I need to create a master/detail form with a strange linkage.
>
> The detail needs to have a where clause like
>
> detail_block_field in
> select (table_value
> from table
> where lookup_value = master_block_field)
>
> Is there any way to get DES2K to generate something like this?
>
> --
> David J Roth
> (My own opinions)
>
Received on Tue Nov 05 1996 - 00:00:00 CET