• Registered: 2014-10-10
  • Posts: 156

Topic: Calculate field for Drop-down menu

Sir,

Calculate field For direct field i am using code...

(SELECT StudentDB.StudentName FROM StudentDB WHERE StudentDB.id = AddCourses.id_StudentDB)

and its working fine. showing Student name.

But.

In Calculate field for Drop-down menu

(SELECT StudentDB.id_AdminStatus FROM StudentDB WHERE StudentDB.id = AddCourses.id_StudentDB) 

it is showing the number in grid table.

i want to show the text belonging to the no written in  Drop-down menu.

please tell for drop down menu, how to write code.

Regards
Nitin Ingale

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Calculate field for Drop-down menu

Hello.

(SELECT StudentDB.id_AdminStatus FROM StudentDB WHERE StudentDB.id = AddCourses.id_StudentDB)

Because in the field StudentDB.id_AdminStatus store id of AdminStatus, not text value.


To fix the calculate field, I need your project.

Dmitry.
  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field for Drop-down menu

You solve it in other project sample.

Thank you very much Sir,
Have a good Day


Regards
Nitin Ingale