Relationship between a custom table and oob table

[RobertPC]

Good morning,

I have created a custom table that extends the task table titled u_md120_release. One the form that I created under related lists I added Change Requests. When I add a Change Request to that list on the MD120 form it does not show up on the Related List I added to the Change Form for MD120. I have looked at relationships and many to many and I cannot determine how to get this to work. I created a new Relationship, but I don't know how to write the script. Any help would be greatly appreciated.

[anshul_goyal]

Hi @RobertPC 

Based on my understanding of your requirement, you are looking to retrieve change request records under the MD120 form. Please confirm if this is correct.

If possible, could you provide more details, such as attaching any relevant screenshots for clarification?

Thanks

[RobertPC]

This is from the MD120 record. I have added a change record to the related list. If I go to the change record, and look at the related list for MD120 it does not show up.

I attempted to create a relationship between the two tables, but it is not working.

[anshul_goyal]

@RobertPC , Your query seems incorrect because you're comparing the sys_id with a number field. Instead, use the following code:

current.addQuery('sys_id', parent.sys_id);
or
current.addQuery('sys_id', parent.getUniqueValue());

Please mark my solution as Helpful and Accepted, if it works for you in any way!

Thanks