Just to reiterate, its not a Primary Key and its not a autonumber, I cannot change to cascade update because it states there is a error, about having records.
I cannot and do not wish to use autonumbers, my stock numbers are set at 5 numbers, the first 2 will identify what the product category...