prabhafriend
12-13-2010, 05:49 AM
Scenario:
Statement1 is having the Category of an account number (PK:Account Number)
Statement2 is having the Code of the Account Category (PK:Account Number)
Reconstatement is having the Category from Statement1 and Code from the Statement2
Table1 is having the list of Account Categories and Corresponding Codes (Many Codes for a Single Category)
Necessity:
Need to display True/False in the Recon Statement Validating Correct Code is given to Current Category. How to do this?
P.S:
No DLookups please. I believe we can achieve using sub-queries but how to use it in expression for this scenario. Work at stake. Help Needed.
Statement1 is having the Category of an account number (PK:Account Number)
Statement2 is having the Code of the Account Category (PK:Account Number)
Reconstatement is having the Category from Statement1 and Code from the Statement2
Table1 is having the list of Account Categories and Corresponding Codes (Many Codes for a Single Category)
Necessity:
Need to display True/False in the Recon Statement Validating Correct Code is given to Current Category. How to do this?
P.S:
No DLookups please. I believe we can achieve using sub-queries but how to use it in expression for this scenario. Work at stake. Help Needed.