UDT with Formatted Search

Michel Wind - Tenax BV

Hello,

I created a UDT with two fields: ItemCode and ItemName. I want the ItemName to be updated automatically based on the ItemCode.

At the moment, I have created a Formatted Search (FMS) on the ItemName field. However, the value is not updated automatically in the UDT. When I click the lookup/magnifying glass icon, the FMS works correctly and retrieves the ItemName, but it does not refresh automatically when the ItemCode is entered or changed.

Is there a way to make the FMS update the ItemName automatically based on changes to the ItemCode field?

Comments

1 comment

Date Votes
  • Comment author
    Dave Gutman

    Hi Michel Wind - Tenax BV ,

    I would use only B1UP components for this.  Begin with a UF of Type ‘UDT Handler’ for the UDT. On that I would set the ‘Formtype Suffix’ (on the bottom of the screen) to a unique value that reflects the use of the screen.  This enables explicit reference to the form ID for the screen generated by the UDT Handler.

    Next use B1 Validation on the Data Load event and on the Item Code field on the Validation event.  These Validations would call a UF of Type Macro, which would read the item name and set it into the desired field.

    This is a summary of the steps, but should give the idea.

    I recommend avoiding Formatted Searches on any screen that has B1 Validations on it.  There are known performance issues with this combination - either use all Formatted Searches, or all B1UP Validations, but not a mix.  There is an excellent Help Center article on this topic that gives the details. 

    Hope this help,

    Dave Gutman  

    0

Please sign in to leave a comment.