2. ASPRunnerPro General questions
  3. [SOLVED]  Field from Another Table to Add Page
This topic is locked
[SOLVED]

 Field from Another Table to Add Page

 		6/25/2010 15:11:45
ASPRunnerPro General questions
J
 Jay123 author

Hi!
I thought I have solved this problem.
I'm trying to get a value from Table 2 and show it to Table 1's Add Page. I have used the following:
Table 2 - Add Page: After Record Added

Session("FieldA") = values("FieldA")
Table 1 - Properties of Field A

Default Value: Session("FieldA")
This works if you will use the browser that you used to enter the value of FieldA on Table 2. However, if you will close that browser and open up a new one or go to another PC and visit the site, the value of FieldA (on Table 1's Add Page) doesn't show up.
Could you pls. advise what am I missing?
Thanks,

Jay
Sergey Kornilov admin 6/25/2010

This is how it supposed to work.
Sessions are valid while browser is open. If you close browser all session variables are lost.
J
 		Jay123 author 6/28/2010

Hi Sergey,
Thanks for the reply.
What's the best solution to achieve this? I appreciate if you can give me a code to get a result. We are working right now with our budget to purchase a support.
Thanks,

Jay
J
 		Jane 6/28/2010

Jay,
you need to select FieldA value from Table 2 in the Add page: Before processevent and fill session variable manually.
J
 		Jay123 author 7/7/2010

Hi Jane,
Thanks for the reply. I was able to come up with another solution. This time, it's for real. Thanks for the support!
Regards,

Jay
A
 		ac163601 7/9/2010



Hi Jane,
Thanks for the reply. I was able to come up with another solution. This time, it's for real. Thanks for the support!
Regards,

Jay


jay, could you post your solution for others following?
thanks