C
Clare
I have a inventory table and I want remove product when it is shipped but
still keep track of the product.
still keep track of the product.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
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)?
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)?
C
Clare
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.
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.
R
Rick B
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.
anything with a shipped date older than two or three years.
R
Rick B
Make that....
I would put the shipped date, and each year I'd do...
I would put the shipped date, and each year I'd do...