View Single Post
  #8 (permalink)  
Old July 29th, 2017, 12:49 PM
billy1r billy1r is offline
Authorized User
Points: 116, Level: 2
Points: 116, Level: 2 Points: 116, Level: 2 Points: 116, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2009
Posts: 25
Thanks: 11
Thanked 0 Times in 0 Posts
Default Code to cut data from one table and paste in another

Does anyone have any idea how to write code to cut data from one table and paste it in another in the same database. I have a database to keep up with serial numbered items complete with a picture (which involves a multi-valued field). As I get rid of items, I would like to cut them from the table and paste them into an identical table I have built called Sold Items.

In fact there are two multi-valued fields, one containing the picture and one with a drop down to choose "Owned or Sold".
Reply With Quote