|
Shopping application.
So I need to create a shopping application. I was thinking for an actual shopping transaction I would create a form that shows the customer ID and then have a list of all the available items in a list box. The list of available items comes from a table called items.
Then because i'm not going to use a bar code scanner or anything I was thinking i would have another list box, so when an item is clicked in the list box, and then a button is clicked it would transfer it into the other list box and those would be the items purchased.
So I had a few ideas on how to do this but don't have a clue to tell the truth. I was thinking that i would need to create a transaction table with Transaction ID, items purchased, and customer ID as a foreign key. So i'm thinking somehow I need for the corresponding details in the items table to get transfered over to the transaction table when i click the button. Is this the right way to go about it? or would anyone reccommend doing it a different way?
Thanks
Grant.
|