On mac and PC. ex. 100 changes to 127 (actual change) and 500 to -20(just example)
I tried on both mac and PC. I am using small int as the datatype and I have made it 3 characters. It changes for two different fields both of which have the same datatype. The key field is the first one changing.
BG:
I am trying to track scratch off tickets and I created a from to enter the scratch off game names, monetary value of each game, starting number, total tickets in a pack etc.