[hi this is nasir sending u a solution fron tree view
Set rs_gl = db.OpenRecordse t("SELECT gl_code, gora,gora & ' - ' & gl_code & ' - ' & gl_name AS " _
& " acc FROM glmas ORDER BY gl_code")
Set rs_link = db.OpenRecordse t("select * from table name")
Do While Not rs_gl.EOF
rs_link.FindFir st "ac_code="...
Leave a comment: