I have a CFormView project and I added an Access Database lookup dialog window. I got it to work if I only have one table in my Database file. Now if I expand to two tables in the same *.mdb file I get an exception error. I used the class wizard to add the the new varaibles and table to the CRecordset Class. What else do I need to do to modify to access two tables? Can anyone help me. I'm new at this database access programming so I might need some extra help. Thanks.
pMyRecordSet->Open(); <--Exception occurs here