One query, different tables?

Hello. I am newbie in this and need som basic help. I have a form witch checkbox'es with different serialnumbers. The serialnumbers reflect different products and every product category have their own tables. I can transfer items from store to truck but can't transfer them back to store. I have 4 stores and like to transfer products between this. I like to to it like this: store_one -> truck_document -> store_two But how can I transfer both Dynamite and Exan in one query to their respective tables? (One table is named exan and the other dynamite.) Thank you very much for your help. I have been searching google but can't find anything about this question. Karl