gj15987

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.

Attached Images

delphi.jpg (25.8 KB, 20 views)