Transfer Between Stores

[Mehvan]

Hello Everyone
How I will transfer between stores
I have 4 stores , I want when I transfer some Items from store1 to another stores to less from store1 and add to store2
for example : I have pipes ( 40*80*1.50 mm ) I have 30 Qy , When I want to transfer 10 Qy to store2 , it appears in store2 10 Qy and less from store1 to 20 Qy

[CJ_London]

not possible to advise without knowing your table structure. Best guess is use a transaction table, either creating two records, one for each store, or one record if table has from/to fields

[ranman256]

Update and append queries.
add items from store1 to 2.
update store1 count with the new qty.

[Mehvan]

This is my example database
Can you correct it to me , please ?
I don't have so much information about Query Append even I do it by Append
If you can help me about it , I will be very pleased