// I want to Edit password,permission of employee<br />
// who have ID="John"  >>>>>>  Account.ID="John" then.....<br />
// Account.Pass="John1" => edit to new password => Account.Pass="John2"<br />
// Employee.Permission=2 => edit to new permission => Employee.Permission=3<br />
<br />
<br />
<br />
<br />
// QLBH2Set.cpp : implementation of the CAccountSet class<br />
//<br />
IMPLEMENT_DYNAMIC(CAccountSet, CRecordset)<br />
CAccountSet::CAccountSet(CDatabase* pdb)<br />
	: CRecordset(pdb)<br />
{<br />
	m_ID = _T("");<br />
	m_Pass = _T("");<br />
	m_Employee_ID = _T("");<br />
	m_Permission = 0;<br />
	m_nFields = 4;<br />
	m_nDefaultType = dynaset;//snapshot;<br />
}<br />
<br />
CString CAccountSet::GetDefaultConnect()<br />
{<br />
	return _T("ODBC;DRIVER=Microsoft Access Driver (*.mdb);DBQ=C:\\MyDB.mdb");<br />
}<br />
<br />
CString CAccountSet::GetDefaultSQL()<br />
{<br />
	return _T([Account],[Employee]);<br />
}<br />
<br />
void CAccountSet::DoFieldExchange(CFieldExchange* pFX)<br />
{<br />
	pFX->SetFieldType(CFieldExchange::outputColumn);<br />
	RFX_Text(pFX, _T("[ID]"), m_ID);<br />
	RFX_Text(pFX, _T("[Pass]"), m_Pass);	<br />
	RFX_Long(pFX, _T("[Permission]"), m_Permission);	<br />
	RFX_Text(pFX, _T("[Employee_ID]"), m_Employee_ID);<br />
}<br />
<br />
<br />
/////////////////////////////////////////////////////////////////////////////<br />
// CChangePassword dialog<br />
class CChangePassword : public CDialog<br />
{<br />
// Construction<br />
public:<br />
	CChangePassword(CWnd* pParent = NULL);   // standard constructor<br />
<br />
	CAccountSet m_Set;<br />
.....<br />
}<br />
<br />
<br />
<br />
<br />
/////////////////////////////////////////////////////////////////////////////<br />
// CChangePassword message handlers<br />
void CChangePassword::OnOK() <br />
{<br />
	.......<br />
	m_Set.m_strFilter = "Account.ID = Employee.Employee_ID";<br />
	m_Set.Open(CRecordset::dynaset,<br />
		_T( "SELECT ALL Account.ID,Account.Pass,Employee.Permission FROM Account INNER JOIN Employee ON Account.ID=Employee.Empoyee_ID" ),<br />
		CRecordset::executeDirect);<br />
	<br />
	// I want to Edit password,permission of employee<br />
	// who have ID="John"  >>>>>>  Account.ID="John"<br />
	// Account.Pass="John1" => edit to new password => Account.Pass="John2"<br />
	// Employee.Permission=2 => edit to new permission => Employee.Permission=3<br />
<br />
	m_Set.Edit();<br />
	m_Set.m_Pass = strNewPass;	<br />
	<br />
	m_Set.Update( ); <br />
	m_Set.Requery ();<br />
	m_Set.Close();<br />
	.....<br />
}

CPA