I tried to get the session registration information using DME call, the following codes work well. But the problem is the department code is meaningless for most of stuff, I wonder how to get department name instead of department number.

Could someone kindly tell me how to get information from more than 3 tables using DME call or other methods?


Codes part:

var object = new DMEObject(user.prodline, "paregister");
object.out = "JAVASCRIPT";
object.index = "regset2";
object.field = "course;session;reg-status,xlt;"
+"reg-date;employee.full-name;course.short-crs-desc;"
+"employee.department"
object.select = "course="+parseInt(cc,10);
Object.select += "&session="+parseInt(ss,10);

DME(object, "FRAME1");

You probably need to do another DME call to the DEPTCODE table.