In an input Form, is there a way to have a numerical field which records as negative the given value ?
In the Table “Stock”, I have “ID”, “ProductID” and “Amount” columns.
In the Form “Delivered” I put the delivered quantity of a selected product.
In the Form “Consumed” I would like a Field where to give the absolute value of the dedicated Product, which will be recorded as negative.
It is important for me NOT to have to type the minus. I am thinking of having 2 columns in the Table (Amount IN, Amount OUT), but this solution doesn’t really satisfies me.
After 2 days of (kind of intensive search I could not find it out… Although it seems to be simple.
Any idea? What am I missing?