Number Changes when saving Data to another Database to a minus Number

[Gary Simpson]

Hi Great People

I have an issue when saving Data into another database.

What is happening is, When I click a Button (Save) The integer number is (1) It is also auto incremented, so when the next lot of data is inserted the Integer Number is (2) When I click the Save Button.

I also insert the data to another database at the same time.

But when I check the data in the other Database the integer number is a minus Number (-1) when it should be the same as the first database (1)

Have any of you Great People Go any Idea's of how to solve this problem.

Pictures Below

First Database



Second Database As you can see The Second Column (Parts Purchased ID) is different from The First Picture (Parts Purchased ID)



Kind Regards

Gary


Gary Simpson

Continue reading...