ok here is the update...
it works as far as placing these orders to a assigned order table. I have to do some more tweeking to get the order over but here it is.
ok here is the process flow prespective
order is placed into a table called titan, orders is then assigned and placed in a table called WorkOrders, then orders are sent to another table called Archive after they have been worked. Orders not assigned are archived automatically. All orders in the archive table are then proccesed for rootcause.
I am going to have to do some massive changes to other queries, forms, reports, and a lot of other objects due to the new WorkOrder table. which explains why I wanted to keep all the data in the orignal titan table. Hey I am not complaing this will work and I am happy.. I do thank you for bearing with me.
I have an idea.. can we delete the data from the titan table after we transfer the info over to the WorkOrder table. then send the information back to the Titan Table thus solving the duplicate order issue?
it works as far as placing these orders to a assigned order table. I have to do some more tweeking to get the order over but here it is.
ok here is the process flow prespective
order is placed into a table called titan, orders is then assigned and placed in a table called WorkOrders, then orders are sent to another table called Archive after they have been worked. Orders not assigned are archived automatically. All orders in the archive table are then proccesed for rootcause.
I am going to have to do some massive changes to other queries, forms, reports, and a lot of other objects due to the new WorkOrder table. which explains why I wanted to keep all the data in the orignal titan table. Hey I am not complaing this will work and I am happy.. I do thank you for bearing with me.
I have an idea.. can we delete the data from the titan table after we transfer the info over to the WorkOrder table. then send the information back to the Titan Table thus solving the duplicate order issue?
Gus Brunston