Updating/inserting >> Linking table

[jason]

A dilemma:

If I am attempting to add multiple products to an existing Customer-Products
linking table do I do this via an Insert or Update?

The first time I enter a customer in the database I would obviously do an
INSERT into the Customer-products linking table.

But, the second time I wish to ADD new products as well as possibly
overwrite existing ones......

I am getting twisted what the correct approach is?

- Jason

[Ray at]

?

Are you adding products, or are you adding transactions (in the sense of
buying an item with money, not a bank transaction or database transaction)?
Where do you store this? What's your database design like?
Customers
--CustomerID

Products
--ProductID

Purchases
--DateOfPurchase
--CustomerID
--ProductID

?

UPDATE updates an existing record, and INSERT adds a new record.

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:OE**************@TK2MSFTNGP12.phx.gbl...

A dilemma:

If I am attempting to add multiple products to an existing Customer-Products linking table do I do this via an Insert or Update?

The first time I enter a customer in the database I would obviously do an
INSERT into the Customer-products linking table.

But, the second time I wish to ADD new products as well as possibly
overwrite existing ones......

I am getting twisted what the correct approach is?

- Jason