My requirements are as follows:
I want to retrieve a CustomerID from the Access 2007 database. After the CustomerID is retrieved, the Customer details are shown in the TextBoxes given below and clicking on the Add New Orders button would allow to add more than one Order Details row or rows for this Customer. After the Order Details have been filled in, the Save button is clicked which pops up a dialog box asking if another Order Detail needs to be filled for the same CustomerID. If user clicks 'yes' then all textboxes are cleared for another new Order Detail to be entered otherwise if the user clicks 'no' then the current new Order Detail is added to the database. In this way many Order Details (Rows of Orders) can be added for the same CustomerID.
Can someone help me with code on how to do this please ?
Thanks a lot !