database app design question
A short introduction to the progam I'm working on. I have a Form View with combo boxes and edit contols. The combo boxes, Buyer & Seller, are populated with the contents of one the tables, Customer Table, in my data from my data.
I also have an "Add" button on my form view. As you can guess, when the user clicks "Add" the contents of the combo boxes and edit controls are added to a record in "Transaction" table.
The code I have now does work. The problem is that I have the steps that add the record into the database are in the Form View class instead of the the Record Set class. This I know is bad programming.
The problem I can't figure out is how can I access the Combo boxes and Edit controls in a Form View class from a Record Set class. I guessing I will have to access the address of the Form View class.
I was thinking:
TmpSet.AddCustomer(Can't figure out what to pass here);