Hello !
I have: (in my head)
A)
tblItemsQuantities
ID_ItemQuantity (PK)
ID_Item (FK)
Quantity (Long) 'Is OK. I need only integers
QuantitySign (Yes/No) ' Yes = Plus , No = Minus
B)
A form based on this table in order to input quantities.
The QuantitySign check box is hidden and I set it's default value in the Open event of the form based on what I need (to add quantities or to subtract quantities).
All this stuff is in order to make things simple for the users (very not experimented either in computers and in math). So, the users will input quantities only with PLUS sign.
So, is there a better practice ? Can I avoid the extra field QuantitySign ?
Thank you !
I have: (in my head)
A)
tblItemsQuantities
ID_ItemQuantity (PK)
ID_Item (FK)
Quantity (Long) 'Is OK. I need only integers
QuantitySign (Yes/No) ' Yes = Plus , No = Minus
B)
A form based on this table in order to input quantities.
The QuantitySign check box is hidden and I set it's default value in the Open event of the form based on what I need (to add quantities or to subtract quantities).
All this stuff is in order to make things simple for the users (very not experimented either in computers and in math). So, the users will input quantities only with PLUS sign.
So, is there a better practice ? Can I avoid the extra field QuantitySign ?
Thank you !