AppWizard -> CDAORecordset for a join

[TimBarnette]

Here's an MFC question:

I'm using AppWizard to build an app. I'd like to insert one CDAORecordset class to do a join across two tables. I couldn't get this to work, though. So, I inserted two classes and walked each table. This really sucks, and I'd rather do a join.

I'm starting to think the problem is that when I did an open I only referenced the one field across both tables I was interested in. Although this works in Access, I think it must be a problem within the Data Exchange to not list all fields on a select in the SQL for a Recordset open?

Does that make sense?

When I brake it up into two classes, it works fine!

Thanks in Advance!

[CornedBee]

Hmm...

Try to define the join query you want in Access and save it in the db. Then add a recordset class based on that query (not sure if the wizard can do it though).