Hi,

I have a problem which I hope someone will help me solve. I have a database where user places orders on ariticles. If the article already exists I want the quantity to be updated +1 or if it is a package +4. How do you find out if the article already exists in the recordset? And how do you update this article. Heres my insert into statement

INSERT INTO tbh (Quantity, Article, Description) SELECT (Quantity, Article, Description) FROM ubh

Now if the article that will be inserted already exists I want to be able to update it instead of creating a new line with the same article.

thanks in advance

//Patrick