Tranfering information from one table to another.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a inventory table and I want remove product when it is shipped but
still keep track of the product.
 
Then include a "shippeddate" in your table. Typically, you don't want to
move things from one table to another. Just change the status of the item
in some way and then include or include items in your queries based on that
status.

What concerns me is what happens next time you get one of those items. Are
the records in your table unique (do you store it by serial number maybe)?
 
Yes each record is unique. It has a pallet#, Box# and date code. We keep
inventory for up to 2 years and my concern is the table will get too large
over tme and it will bcome slow for reports. So I thought if I could remove
the shipped product into another table it would stay manageable.
 
I would put the shipped date, and year I'd do a delete query to remove
anything with a shipped date older than two or three years.
 
Back
Top