Hi all, I am new here. Please pardon me if I am not posting my question clear enough. Thank you for your help in advance.
We have an inventory database, a table that has live data, and there are some other tables for different pending status, we want to review these records before we process them to the live data pool.
To make it clear, data entry team will enter records into the pending installation, receiving, relocation, de-installation...etc, tables for review and they they will be send to the live database after it.
Now, the challenge is that if we want to look up a serial number to see what is the status, we will have to look it up from
To save time, we are thinking to combine all these data into one single table, and we can just query that serial number in just one single table.
Questions are, how can we do this automatically and how to delete all the old records before we import the new data?
Have a nice weekend and thank you a lot.