Custom Application: Parent/Child Table Relationship Configuration Issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-25-2022 11:30 AM
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:
From there, I created a new relationship between the parent and child table:
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.
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-25-2022 11:40 AM
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();
Aman Kumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-25-2022 12:36 PM
I added the query script in the relationship, however, now no tasks are populating in the related list. Any other ideas?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-25-2022 12:59 PM
Have you created record for child record for the parent record?
Can you share the snapshot of the script, what you have written
Aman Kumar