Custom Application: Parent/Child Table Relationship Configuration Issue

Theresa Heide
Tera Contributor

Looking for some assistance with two tables extended from TASK in app engine studio. I am trying to create a custom table tied to a record producer that will ultimately kick off a flow in flow designer. I have followed the steps to create the relationship on the child table with the u_parent field referencing the parent table, see below:

TheresaHeide_0-1666722542553.png

 

 

From there, I created a new relationship between the parent and child table:

TheresaHeide_1-1666722542538.png

 

 

My issue is when I configure the parent record form to pull in the related list relationship, it pulls all records from the child table rather than the tasks specific to that record creation (the tasks are outlined from the flow designer tasks linked to the child table). As can be seen from the screenshot, when I pull in the parent and the u_parent fields to the related list, it is saying (empty) for all as seen below.

TheresaHeide_2-1666722542571.png

 

 

This is making me think there is an issue with the parent child table connection or the relationship I've created. Can someone help assist me in ensuring the related list has the correct child records in the related list? What am I missing?

I have tried extending both the parent and child from TASK and linking as well as extending the parent from task and the child from the parent table with no success.

3 REPLIES 3

Aman Kumar S
Kilo Patron

You don't need to explicitly create a relationship between the parent child tables in order to show the relation, if child table is extended, you will automatically have that created for you, you can follow below link for the same:

Create parent child relationship automatically on related list 

 

and if at all you want to use custom relationship, you will need to add correct query in the script:

 

var queryString = "u_parent=" + parent.sys_id;
current.addEncodedQuery(queryString);
current.query();

 

Best Regards
Aman Kumar

I added the query script in the relationship, however, now no tasks are populating in the related list. Any other ideas?

TheresaHeide_0-1666726571502.png

 

Aman Kumar S
Kilo Patron

Have you created record for child record for the parent record?

Can you share the snapshot of the script, what you have written

Best Regards
Aman Kumar