Update Query causing duplicate data? (1 Viewer)

H

hubare

Guest
I'm ot sure if this is the right place to post or if it's been asked before but I've been sat staring at my PC for about 2 hours (probably without blinking) and I'm close to murder!

from a web page... I am attempting to update a table with a composite primary key. These key fields are also linked to other tables... All i'm basically wanting to do is decrement a stock level by one like so...

UPDATE tblSourceType
SET Currentstock = CurrentStock-1
WHERE (SourceId = 'TWW1')
AND (MagazineId = 'HF1')
AND (TypeId = 1)

All three criteria 'WHERE' fields are the primary keys but i dont understand why it says it will create a duplicate record bearing in mind im not updating any of the primary fields... Also, when i put it directly into the Access Query window, it works fine :(

Any help.. or an explanation would be greatly appreciated
 

Users who are viewing this thread

Top Bottom