CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 [RESOLVED] moving data from one table to another

Print topic Send  topic

Author Message
Chris__T


Posts: 339
Posted: 07/19/2010, 10:00 AM

I'd like to take some data (fields) from a record on a page, and put that data into a different record on a different page. The records are linked to different tables.

Page1. Record connected to Table_A. Has First_Name field, Last_Name field

Page2. Record connection to Table_B. Has First_Name field, Last_Name field

how to get the data from page1 to page 2?
View profile  Send private message
Jan van Dalen
Posted: 07/19/2010, 10:54 AM

Hello Chris__T,

Chris, need more info for a proper recomendation. Do you want the record
to appear on Table B when you add a record to Table A?

> I'd like to take some data (fields) from a record on a page, and put
> that data into a different record on a different page. The records
> are linked to different tables.
>
> Page1. Record connected to Table_A. Has First_Name field, Last_Name
> field
>
> Page2. Record connection to Table_B. Has First_Name field, Last_Name
> field
>
> how to get the data from page1 to page 2?
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/

Chris__T


Posts: 339
Posted: 07/19/2010, 12:47 PM

Ok, sorry I wasn't clearer.

Let's say I have a record open on a webpage. It is showing First_Name and Last_Name fields, and those are filled in with John and Doe from the table the record is accessing.

Page1:
First_Name = John
Last_Name = Doe
this data is from TableA

I want to click a button, and it goes to page2, taking "John" and "Doe" with it, and sticking it into Page2's First_Name and Last_Name fields. But when they hit SUBMIT button on this page, I want the data to go into TableB
View profile  Send private message
Jan van Dalen
Posted: 07/19/2010, 1:57 PM

Hello Chris__T,

2 ways of doing them:
a) Using URL Passed Variables
b) Using Session Variables

Then on our Table B form, just default the value of the fields to either
the URL or Session variable.

Should work 100%

> Ok, sorry I wasn't clearer.
>
> Let's say I have a record open on a webpage. It is showing First_Name
> and Last_Name fields, and those are filled in with John and Doe from
> the table the record is accessing.
>
> Page1:
> First_Name = John
> Last_Name = Doe
> this data is from TableA
> I want to click a button, and it goes to page2, taking "John" and
> "Doe" with
> it, and sticking it into Page2's First_Name and Last_Name fields. But
> when they
> hit SUBMIT button on this page, I want the data to go into TableB
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/

Chris__T


Posts: 339
Posted: 07/21/2010, 7:33 AM

I tried (a) and it worked like a charm. Thanks!
View profile  Send private message
Jan van Dalen
Posted: 07/21/2010, 7:54 AM

Hello Chris__T,

You are welcome :)

> I tried (a) and it worked like a charm. Thanks!
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.