multiple table in MFC

how to connect multiple table in MFC in a single dialog based app with header file
reenajasmineAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndyAinscowFreelance programmer / ConsultantCommented:
Make a query based on your tables, base a recordset on that query.  Is that what you require?

eg an SQL such as :
SELECT Adressen.Kurzname, Auftragsadressen.AuftragID
FROM Adressen INNER JOIN Auftragsadressen ON Adressen.PSID = Auftragsadressen.PSID;


0
TriskelionCommented:
Use the class wizard.
Make a CRecordset class.
The interface will present all of your tables.
Click on all of the tables you want to join and click OK.

Back in your code, you will need to modify the m_strFilter as it will contain your WHERE clause.
The WHERE clause is very important as it will bind the results from one table to the other.
The m_strFilter will not need to include the word 'WHERE'.
0
AndyAinscowFreelance programmer / ConsultantCommented:
My comment would be a way to achieve the desired effect
0
DarthModCommented:
Submitted to PAQ with no points refunded (of 20)

DarthMod
Community Support Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.