Create Relationship & Populate Parent field

litchick10
Tera Guru

I know this is really basic but I can't seem to get my system to work.  We are on Vancouver. 

 

We create a table extended from Task called 'u_risk_escalation' and I'm trying to create a relationship between 'risk' table and the new table.  However, the parent field isn't populating nor is the risk relationship showing correctly

Risk related lists: 

Related_List.png

Risk Escalation table from Related List:

risk_escalations.png

u_risk_parent is a reference field to the "risk" table

 

Relationship: 

Relationship.png

 

Can someone help me figure out how to populate the 'u_risk_parent' field when the "New" button is selected from the related list?  Everything I've read says establishing the relationship should cause it to auto populate but it just isn't working for me. 

1 ACCEPTED SOLUTION

SanjivMeher
Kilo Patron
Kilo Patron

You relationship script should have been

current.addQuery('u_risk_parent',parent.sys_id);


Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

4 REPLIES 4

SanjivMeher
Kilo Patron
Kilo Patron

You relationship script should have been

current.addQuery('u_risk_parent',parent.sys_id);


Please mark this response as correct or helpful if it assisted you with your question.

Hi @SanjivMeher ,

can we design relation based more than one field ? like below ?

current.addQuery('u_risk_parent',parent.sys_id);
current.addQuery('u_risk_id ',parent.u_risk_id);

Yes. It should work. Try it out


Please mark this response as correct or helpful if it assisted you with your question.

litchick10
Tera Guru

Doh!  Thank you