Not sure I have my relationships correct...

[sassenach]

Hi everyone,

I am trying to build a little shopping cart. I think my major problem is the relationships. I can't seem to get them right.

My major problem is adding items to the shoping cart (basket).
I guess 1 item can go in many baskets and a basket can hold many items. Make sense?
so i have my tblItem & tblBasket, and then I made another table called tblConnectBasketItem, which holds the itemid & basketid.

In any rate, this is where I got confused.

If someone can look over my DB, and give me some pointers, that would be great and thankfull.

You can find my DB attached.

Thanks again,
Sass

 

[steallan]

one item type can go into many baskets, but one item (i.e stock item) can only go into one basket, coz once it's sold its gone right?

 

[sassenach]

not, not really

im selling flowers, so these flowers can be sold over and over again.
what do u suggest?