Hi all,

I am doing a movie application an I need your advice. At the moment am doing the GUI for lending out the movies. I have a combobox (lookup table) for holding the customer details from the customer table and another combobox (lookup table) for holding movie titles from the movies table. The idea is when I select a customer from the combo, and then select the movie they want to borrow, when i click on a command button (cmdSelect), the selected movie in the movies combo should be transfered into this control where it is listed as selected. (Like it is done in the supermarket applications where each item you buy is scanned and its details appear in a grid like control that indicates item description, price, discount etc) A user is allowed to borrow a maximum of three movies per day. All the selected movies should be held in a listed format in this control. After the selection, there is another command button (cmdCheckOutAllSelected) which when clicked, all the selected movies should be inserted into an orders table indicating the customer id, and the three or less movies that are appearing in this control. Note I should also be able to remove a selected movie from the control

1- Can this be implemented? If yes, which is the best control that can hold these selected movies and which can be manipulated using code to INSERT the selected movies into the DB?
2- how can I code to ensure that the selected movies are inserted into the DB

Does this make sense?

thanks