Re: Call one form from another (SQLFORMS)

In article <1992Dec9.150558.16060_at_cbfsb.cb.att.com>, colten_at_cbnewsb.cb.att.com (marc.colten) writes:
>
>
> I need to link two different forms that use the same keywords.
> That is, if a user enters "XXX" in a certain field, I want to
> call another form using XXX as a key. I know I can use CALL
> to bring up another form, but I don't want the form to come up
> blank. If the user enters XXX is there a way to bring that value
> to a particular key field in the next form and run the execute
> so the right values come up automatically?
>
>
> thanks in advance
>
> marc colten
>

-- 
    Try this:

    1.  use global parameter to pass the value of the key field to
        form you want to call next.

                :global.key := 'XXX';

    2. In called form's KEY-STARTUP-trigger copy the global value
       to another field and start the query for the block you want.

                :dummy_block.key := :global.key;
                execute_query;

    3. Define block's query as follows:

                where :block.key like :dummy_block.key

    4. In order to be able to do other type of queries in same
       block, you have to expand the key field into '%' in
       KEY-ENTQRY-trigger:

                :dummy_block.key := '%';
                enter_query;

    Hope this helps!
    -Mikko Kuismin