hi Rafael,
Thank you so much, it works now.
But it leads to another problem
We cant reference and make it part of 2 tables?
I make outbound order table as parent , inventory as child, and make it " is part of"
I do the same to inbound, but i cant save and restructure it.
is there any other way can do it? as outbount the amount will be negative, inbound is positive
there fore i create 1 inbound and 1 outbound