Is it possible to create a shopping Cart in Access?

[emiljan]

Hey guys,

Would it be possible to design a shopping cart in access? Something similar to other shopping carts out there like amazon or newegg, but enterly in access using forms, queries, and reports only.


Thank You,

Emiljan

 

[gemma-the-husky]

i would have thought you could achieve any "look and feel" - except that access doesn't lend itself to web-based development, if that is what you are trying to do. There are some web capabilities but others here are far more experienced with them than me.

 

[DavidAtWork]

I don't any reason why not. A shopping cart is just an array/list of records a user has selected. You would need to base your design on giving the user a mechanism to select an item, then record what has ben selected in an array or temp table. The fields in the array/table would be determined by the complexity of the products ie productID, price, type, size etc.
At checkout you'd simply list all the items contained in the array/temp table on a form/report with a price total