I want that if I enter a value to the "Units In" in the Stock Transaction Portal it will not add in the calculation on my "Units on Hand"
Why not? If you receive 10 units from your supplier, would you not want your Units on Hand to go from 21 to 31?
and I want also that If I enter a value to the "Units Out" field in the Stock Transaction Portal it will automatically enter the remaining total quantity in my "Units In" and it will also update my "Quantity on Hand" field.
The remaining total should be in the Units on Hand field of the Inventory table. And each transaction row should be EITHER an In OR an Out, not both.
A better way to set this up would be to prevent the user from creating a transaction that is both in or out.
See if the attached helps.
Inventory v2.fmp12.zip 361.2 K