AUTOFILL SUCCESOR

Hi,

currently, i am facing problem, i have three tables

table 1 depend is stocks table, that depends on table OUT and table IN.

i need table OUT entry to be automatically update stock table including multiple entries as shown , however table in values should distribute accordingly.
eg.

if out is 576 and in is 998, then 576 should auto fill in first row, remaining be update as we go down.

thanking you

harshul,