hi. VB6 FAQ

i been tasked to write an order tracing system for the sales dept and so in some instances i need to create a table during runtime. how do i go about it

Under what cirumstances would you want to create a table? All tables should already exist.

i wanted to create it when updating some of the orders so as to keep track of the dates when those orders were updated.
the thing is like
when a customer comes and gives us an order, we enter the order in the DB. say the order is for 10000 boxes. if the factory guys run 5000 boxes on a particular day and the other remaining on other days, i would want to keep track of the days the boxes were run. how do i keep track of the dates