Pankaj_Agarwal wrote: Both the tables have no relation at all with one another. In such a case what to do. Start over. When AppWizard asks you for the table, only specify one of them, then create the other using ClassWizard. Or, create the application with no database support, then use ClassWizard to create two classes derived from CRecordset. "Opinions are neither right nor wrong. I cannot change your opinion of me. I can, however, change what influences your opinion." - David Crow

Thanks....this is one method that did not strike me....this can be done and i am sure it will work. But usually what happens is that in the class wizard we get a combo box in which all the member variables are stored by default, we just have to choose for which resource which field variable we have to assign. In this case no coding is required. But as you said i think by coding in this manner, the work will be done. Anyways, Thanks a lot !!! Regards, Pankaj

2 posts before, i said : this[^] TOXCCT >>> GEII power