\r\n\r\n
Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > Database and Reporting > Select From/Insert Into


\r\n \r\n
 
 
Thread Tools Display Modes

\r\n\r\n\r\n
I am trying to figure out the easiest way to copy values from one table to another. I have two tables in an ms access database: Hardware and Archive
\r\nRight now, when Hardware is returned from a shipment, the transaction number is set to "0" to indicate the item is back in stock. Before that takes place, I would like to write the transaction number (transaction_no) and the hardware id (key_id) to the archive table as a cross reference so users can see what hardware was associated with which transaction.
\r\nIs there a way to select the transaction_no and key_id from Hardware and write those values to fields with the same names in the Archive table?
\r\nI have been trying to find an example somewhere. I can\'t believe I am the only person ever to have this problem
\r\nThanks in advance for any help
\r\n \r\n\r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n
\r\n __________________
\r\n "I don\'t want the world - I just want your half."
\r\nThey Might Be Giants
\r\nLorena\r\n
\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n'; pd[1105969] = '\r\n\r\n \r\n\r\n
\r\n
\r\n
\r\n\r\n
\r\n \r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n
\r\n
\r\n  \r\n #2  \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n Old\r\n \r\n 01-23-2006, 12:33 PM\r\n \r\n \r\n \r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n
00100b\'s Avatar\r\n\r\n
\r\n \r\n 00100b\r\n 00100b is offline\r\n\r\n\r\n
Prev Previous Post   Next Post Next
  #1  
Old 01-23-2006, 12:16 PM
lroyce's Avatar
lroyce lroyce is offline
Regular
 
Join Date: Feb 2002
Posts: 57
Default Select From/Insert Into


I am trying to figure out the easiest way to copy values from one table to another. I have two tables in an ms access database: Hardware and Archive
Right now, when Hardware is returned from a shipment, the transaction number is set to "0" to indicate the item is back in stock. Before that takes place, I would like to write the transaction number (transaction_no) and the hardware id (key_id) to the archive table as a cross reference so users can see what hardware was associated with which transaction.
Is there a way to select the transaction_no and key_id from Hardware and write those values to fields with the same names in the Archive table?
I have been trying to find an example somewhere. I can't believe I am the only person ever to have this problem
Thanks in advance for any help
__________________
"I don't want the world - I just want your half."
They Might Be Giants
Lorena
Reply With Quote
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->