Kinetic App Studio: UD07 RowChanged Not Firing on First Load, UD06 Grid Not Populating

Kinetic ERP
1

Hoping someone can help with this.
I’m trying to get UD06 data to load automatically when a record is first opened, based on the default row in UD07. Here’s the full setup:

I’ve created a custom Kinetic App called PCR that uses three UD tables: UD05, UD06, and UD07.

Table Relationships

  • UD07.PCRNum_c = UD05.Key1
  • UD06.PCRNum_c = UD07.PCRNum_c
  • UD06.ParentPartID_c = UD07.Key1

Screen Layout

  • The Parent Parts grid is bound to UD07
  • The Component Parts grid is bound to UD06

Current Behavior

I created a RowChanged event on UD07 so that when the user selects a different UD07 row, the corresponding UD06 data loads.
This works perfectly after the page is already open.

The Issue

When the screen loads for the first time:

  • The default UD07 row is shown
  • BUT UD06 does not load the related records
  • The user must manually select another UD07 row and then return to the default row to get UD06 to refresh
  • If there is only one UD07 row, the user cannot trigger RowChanged at all—so UD06 never loads

What I’ve Tried

I attempted to use a Window On Load event to manually pull UD06 data during initial load, but this didn’t work.

What I Need

A way to make UD06 refresh automatically based on the initial default UD07 row when the form first opens—without requiring the user to click anything.

Has anyone solved this before or found a reliable trigger to force the first-row load?

2

Why don’t you use one of the parent/child UD tablesets and entry screens where this is handled for you? UD101/101A-105/105A.

3

I need to join three tables though. Do any UD tablesets handle this?

4

If executing rowchanged event populates your data correctly, in your onload, call your rowchanged event in an event-next.

5

Those don’t fire reliably. Use the on create event of some control on your page instead.

6

Hi Gabe,

Thanks for the suggestion, however this didn’t work.

This is the event for the rowChanged

image
image399×253 8.19 KB

Perhaps the trigger is blocking it when the Window OnLoad event fires?

image
image650×239 9.2 KB

Thanks,

7

Managed to resolve this by creating a new event to GetsRows on UD06 with no trigger. (BO_UD06_Refresh)

image
image350×233 7.16 KB

Then used an existing GetRows event for UD07 (BO_UD07_Refresh) and added a next-event to BO_UD06_Refresh, with the Window onLoad trigger.

image
image415×222 9.2 KB

Now all rows linked to UD07 load on UD06 when the page loads.

Thank you all for your input.

1 Like