Save Data in Assigned Variable

Jay,
you can create a global variable in the After application initialized event on the Events tab.

Thanks, Ann.
Can you pls. give an example on how to declare and assign variable?
For example, field1 on table2 should be equal to field1 on table1 when the Add page of table1 gets displayed.
Thanks,

Jay

Jay,
to declare variable in the After Application initialized event use the code:

then use the variable in the events:

Hi Ann,
Could you pls. explain more on this?

gl_var=5

gl_var+=1
If I'm going to assign x as the variable for field1 on table1, how will I declare it in After Application initialized or in the Event?
Thanks,

Jay

Jay,
use Data Access Layer(DAL) functions to select record values of field1 from table1:

http://xlinesoft.com/asprunnerpro/docs/data_access_layer.htm

Hi Ann,
I have tried that before but that didn't work in my current situation. The dal didn't work in Add Page before display event.
The session variable wouldn't work in my case either since the administrator will enter the value of "field1" on table2 and users (who are using different machines) need to see the value of "field1" on table1.
The technique that I have used before was to use a lookup wizard and it worked. However, my situation this time is a bit different so I would like to store that value of field1 as a global variable and can be pulled/used from different tables.
Thanks,

Jay

Jay,
it's difficult to tell you what's happening without seeing actual files.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error. 'Demo Account' button can be found on the last screen in the program.

Hi Ann,
I have opened a ticket and attached a screenshot of my table. I've tried the demo account but for some reasons, it's not going through. It is probably blocked by our Network Security.
Thanks,

Jay