I am trying to create a database for an inventory that is continuously changing. I have created 12 tables that contain the inventory for each specific location. I would like to create a seperate spare parts inventory that would keep only the spare parts that have not been installed. The problem lies when I install a part from the spare parts inventory table it does not move the part identification information into the roper specific location invenotry table. I would like to possibly create a way to allow the program to automatically do a search to pull the items information and move it into the necessary table for proper reporting information, and delete form the spar parts inventory. I am lost and frustrated. There might be a simple way, but I am new and dumbfounded when it comes to SQL language. Any help would be greatly appreciated. Thanks.
