Yes, you need 2 tables, one for the store inventory and one for the shopping
cart.
As the user picks items, you insert them to the shopping cart, with the user
name as part of the key. You might want to have one shopping cart table per
user, it depends on your design.
You will need to allow for creating, updating and deleting shopping carts.
Dorian
If you really mean to build a web based shopping cart based on Access, then
simple gets somewhat harder. You have to use some web based technology to
provide the user input, select, update, checkout functions. Then
considering secure web payment --we're way past 'simple'.
Ed Warren.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.