Relationship between two tables?

[reddy01]

Hi All,

How to build a relationship between   2 tables . I had a table   dtask which is extended from demand . Need a relationship between dtask and stake holder table which related list to demand.

Thanks

[reddy01]

dtask table was extended from demand.

stake holder table was related list   to dtask

main task was when approver is yes in stake holder then it should auto change state in dtask from draft to submited.

[Harsh Vardhan]

Why don't you use business rule.

create a business rule on 'stake holder' table and do query.

this is just an example.

var test= new GlideRecord('incident');

      test.addQuery('problem_id', current.sys_id);

      test.query();

      if (test.next()) {

              test.state = '3';

              test.update();

              gs.log('Found Problems related to this INC ' + test.number , 'debug>>');

      } else {

              gs.log('No Problems related to this INC' + test.number, 'debug>>');

      }

Thanks,

Harshvardhan