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