Assume I have a table of parts for a particular job. Parts are added to the job as they are needed. Some times a given part is needed more than once so I could potentially have multiple parts show up in the table. To avoid this I'd rather just have a quantity field so that would increment instead.

Is there a way to make an INSERT statement add a part if it doesn't already exist OR increment the quantity if it does?

Thanks!