This question has been flagged
1 Reply
2867 Views

I have table fields are Employee Name, Target, duration.. in that table all the employee name(the person who is from sale department) from the he.employee table should automatically come to my field Employee name how to do that advance thanks....

Avatar
Discard
Best Answer

Hello Gpkarthick,

First of all define this Employee name field as a dynamic selection field eg:

employee_names:fields.selection(get_employees,'Employee Name)

Create this get_employees function which fetches from the hr.employee table those employee's that belong to sales department and finally return [(id1,name1),(id2,name2)]

Thanks,

Avatar
Discard
Author

explain breafly plz