Question regarding Editing a selection field using another form example

Applications Forms
#1

In this example: Editing a selection field using another form http://www.scriptcase.net/sistemas/v6/exemplos_en_us/form45/form45.php

Beside the Category field, there is a Edit button (To edit Category click in).

When this button is click, it launches another application Category.
(http://www.scriptcase.net/sistemas/v6/exemplos_en_us/form45_1/form45_1.php?nmgp_url_saida=&nmgp_parms=sc_redir_atualizscinokscout&nmgp_outra_jan=true&nm_evt_ret_edit=do_ajax_form45_lkpedt_refresh_categoryid) .

Are we able to pass the value of the field so that when it launches the other form, it will bring me to the record of the field for editing?

e.g if I select category = SEAFOOD and then click on the Edit button, when it launches the Category form, instead of displaying the first record in that table, but display the record category = SEAFOOD.

#2

Re: Question regarding Editing a selection field using another form example

Yes, this what I need.

How can I pass the value to new form application by edit button, for that record.

#3

Re: Question regarding Editing a selection field using another form example

  1. create a gloabl variable and pass the category value to it in the onRecord event.
    e.g [catg] = {category};

  2. Under application, select global variable and change the type of global variable as OUT

  3. Open the Category Form, and under SQL add in the following statement at the end of the SQL statement.

WHERE
Category = [catg]

#4

Re: Question regarding Editing a selection field using another form example

YESSSS!!!

Thanks, leadtheric.