Good morning plog! And I am happy to say that I am off to a roaring start!!!
I built the Append query and transferred everything back into the Parts table. I then ran the Update query for each part used, and everything went VERY smoothly! (except for the fact that I apparently can't spell battery!)
So now I am left with the individual tables (that I believe that I do not need anymore), and the original fields in the ServiceSpecs table (Oil Filter, Air Filter, Fuel Filter, & Battery).
Do I need to delete those columns now? And can I delete those individual tables now? And, lastly, is my form still going to work properly?
I await your response...
I built the Append query and transferred everything back into the Parts table. I then ran the Update query for each part used, and everything went VERY smoothly! (except for the fact that I apparently can't spell battery!)
So now I am left with the individual tables (that I believe that I do not need anymore), and the original fields in the ServiceSpecs table (Oil Filter, Air Filter, Fuel Filter, & Battery).
Do I need to delete those columns now? And can I delete those individual tables now? And, lastly, is my form still going to work properly?
I await your response...