Shopping Carts

I'm having problems trying to set up a simple shopping cart. Basically the way I've tried to go about it is to have a shared datatable then add stuff to that. Which is fine if I'm the only one using the system however at the moment everyone using my system is using the same datatable so has the same items in thier cart.

I've tried making it a local variable but then I have a problem that each time you add an item to the cart you overwrite the previous cart so it only ever has one item.

I find if I make it a non shared variable then the columns are not kept from when I initialise them when I load the form. This happens if I have the variable as public shard, private shard or just shared.

Am I going about this entirely the wrong way? My only plan is to add a user column to the data table & give everyone user specific dataviews of the datatable but this strikes me as a bit of a sketchy work around rather than a proper solution. Can anyone help with this?I think U have to use session id, which is Identical for each user. All the Items selected by the user entered in to the data base which contains sessionid column. When user select save the cart u just select those items which belongs to that session only.

It will help u in one more way. Suppose any user select some items, which r added to the database. But that user does not the save cart & close the session or explorer window. When the Session_End event is fired u can remove the data ( which is of no use for u) from the database.

Is it help U ?
I've sort of made it work in that way now, thanks.