problem with application link on form

Applications Forms
#1

hi,
I have a Big problem
I have created an application link in a form (F1) to an other form (F2) but I don’t understand how pass the parameter : I define the field but the F2 don’t receive the value. I hav to set something?

thank you
max

#2

Re: problem with application link on form

Hi,
when you create Application, in the Target application say (F2) should have a parameter defined and based on that it should populate the value then follow the below steps

  1. In SQL give the parameter in the where Condition, the parameter name with squre braces ‘[]’ ex: [v_empname]

  2. When you run the application It will ask for the parameter and the F2 form will filter record based on that

  3. In the Parent form you directly Link the application with the parameter or sc_redir() can be used.

There are sample applications desribes this…!

Regards
Dhana

#3

Re: problem with application link on form

hi,
thanks per the interesting…

in F1 I have just create a record so when I arrive in F2 I haven’t record to filter, But I have just to insert record in F2

i work in mysql :
table1 : pra_id = Primary Key (is an incremental value in Mysql)
Table2 : seq_id + pra_fk_id = primary key
seq_id is an incremental value in Mysql
pra_fk_id is the value that I pass from F1 to F2

I define a global variable in initial value of then field in F2 and assigned in Link of F1 but don’t do nothing … :-(((

#4

Re: problem with application link on form

Open the F2, go to the menu SQL and define a where codition:
pra_fk_id = “[var_pra_id]”

Go to F1, do the link again, passe the F1 pra_id to F2 [var_pra_id] and be happy

#5

Re: problem with application link on form

Hi there!

Let me please reactivate this thread.
I followed the steps above to pass a value to my form application.

If I click on “new” to insert a new record (without reloading), how can I use the variable again?

#6

Re: problem with application link on form

Hello,

How do you want to use the variable again?

regards,
Bernhard Bernsmann

#7

Re: problem with application link on form

Thanks for your help.

Meanwhile I managed to get it done by the use of [<var_my_field>] in the target form application.

Anyway, thanks for the help!