Hi,
So i have a table that essentially has multiple components so say, a serial code, a price, and an item description. Let's say we currently have items a-k
I have a user that uses "item d" in the current database. Now lets say I have a new inventory. This inventory includes items h-z. *notice how h-k includes an overlap. I need my table to now include items a-z properly. that way if someone wants to go back and change passed item information they can, and i still have current inventory. so although we are going to be using items h-z in the future, we still need to get rid of all of a-h. but the way i am using this database: although we need to get rid of inventory a-h, i want it to always remain in the table regardless (if that part isn't possible tell me!).
I have the old table there still, and I can make the newer table as a table of itself. I need to find a way to simply merge them.
Any ideas?
So i have a table that essentially has multiple components so say, a serial code, a price, and an item description. Let's say we currently have items a-k
I have a user that uses "item d" in the current database. Now lets say I have a new inventory. This inventory includes items h-z. *notice how h-k includes an overlap. I need my table to now include items a-z properly. that way if someone wants to go back and change passed item information they can, and i still have current inventory. so although we are going to be using items h-z in the future, we still need to get rid of all of a-h. but the way i am using this database: although we need to get rid of inventory a-h, i want it to always remain in the table regardless (if that part isn't possible tell me!).
I have the old table there still, and I can make the newer table as a table of itself. I need to find a way to simply merge them.
Any ideas?
Last edited:
