Hi Jason - Thanks for the quick response.
Sure this is my lack of knowledge here again but I am keying into the Shop ID, I can demonstrate that by putting the ID into the cart to confirm that I have correct column as the number from the shop ID is that of the Product table ID. It works perfectly when there is only one item in the cart, it is not working though on subsequent additions to the cart, it is as if it is not seeing the repeat of the items being added to the page.
I have just been testing this further and now convinced the cart has something wrong and perhaps the reason for my initial problem as well, when I have more one item in the cart and I select to remove the 1st record in the page from the cart it delete all records and not just the one selected, if I do the same on 2nd or 3rd record it just removes the item selected as it should do, so I think there is something wrong with the way the page is seeing that 1 record in the list. Any simple ideas or should I just delete this cart and set it up a new new one?
Hope this makes sense.