Secondary IDO Field in Datagrid

Ryan Pukanski

Hi everyone,

I have a question about Grids on forms. I am not sure if I am missing something really obvious or if this is supposed to be strange.

I have a custom IDO with a custom table joined to the SL items table. The custom table has the item property on it and I have done a secondary join to the items table on item=item. I added the description property from the items table to this IDO.

Everything works fine but I am trying to use this item on a datagrid in a CSI form. When the users fill out the form I have validator to ensure the item number is valid and they can continue on entering data. The one thing that I can't figure out is getting the description to populate after the item number is entered.

After the collection is saved the item will populate no problem.

I have tried using some of the standard event handlers, component class on the description field, etc but I cannot figure out if there is a built in way to do this or if I have to code in my own formscript. Can anyone shed some light on this one for me?

CSI 10.493, MG 2020.10.

Thanks a ton!

Ryan

kazuyuki-mochizuki

maybe because it is not yet saved to the db and the ido still doesnt know what items to link between your custom table and items table?

maybe you can call a Load Collection event on your validation to set the component or property value of your description right after validation.

Pic below is Filter the items collection based on component/property and then assign the return value to a component/property 

or you can play around with "Set values" option inside the validators, I think this is almost the same as the load collection in the event handlers.