How to access other tables in a Database

Hi

I am connecting to a Ms Access database through a DAO.

There are say more than 1 table in the database.

Now i have connected one table of the DB to the Set class.

I donot want to disconnect from this table & at the same time to validate the data

entered in that table i have to access the data present in other tables of the DB

For this i have created one new class through the ClassWizard. & attached to

the other table but when i use the DAO functions like MoveFirst & so on the m_pSet

variable is not connected to the variables in that class

How do i solve this problem??

or is there any other way of doing it?

Thanx in advance

Prasad

u can contact me at

indla.prasad@usa.net
[826 byte] By [I S Prasad] at [2007-11-15 22:06:48]
# 1 Re: How to access other tables in a Database
Class Wizard -> Class name: CYourRecordSet -> TAB "Member Variables"->

->batton "Update Columns"

Then the same actions like from the creation of your MFC application and

Ctrl+Enter on any tables you want to add. BUT !!!

RecordSet like this IS NOT UPDATABLE !!!
Dmitry at 2007-11-10 3:08:00 >