web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Disable Manual Entry l...
Microsoft Dynamics AX (Archived)

Disable Manual Entry lookup

(0) ShareShare
ReportReport
Posted on by veera seenivasan 575

Hi Experts,

               

i Have a grid in a form.which has several fields(String edit) there are lookups on these fields as well.

the string edit field save the anyvalue (typed in by use or values from lookup)..i dont want this to happen the string edit should take values only from the lookup field.

is there any property that i need to change for this?

Thanks&Regards

Adam

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    DavidGunawan Profile Picture
    DavidGunawan 1,381 on at

    Hi,

    The edit field is related/lookup from other tables? If yes, then it will do the validation. If no then you can override validateField() method of the table/datasource. You can put your validation logic in the method.

    Regards

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,990 Most Valuable Professional on at

    I agree with using a validation. Don't try to force users to use the lookup form; they may have a valid value copied from elsewhere and they should be able to paste it to the string field. It's important for their productivity.

  • veera seenivasan Profile Picture
    veera seenivasan 575 on at

    Hi David,

                  I have added this code but it validation showing for both manual entry field and value selected from the lookup .how to avoid this

                public boolean validate()

    {

       boolean ret;

       ret = super();

       if(smaagreementline.ServicePlanId)

       {

           ret = checkFailed("plan is already suspended");

       }

       return ret;

    }

  • Verified answer
    DavidGunawan Profile Picture
    DavidGunawan 1,381 on at

    Hi,

    You can't just do simple validation of blank value.

    If the value of ServicePlanId comes from the lookup then you need to validate whether the value exist the list of lookup (either from other table or fixed list, etc).

    For example:

    public boolean validate()

    {

      boolean ret;

      InventTable  inventTable;

      ret = super();

      if(InventJournalTrans.ItemId)

      {

          inventTable = InventTable::find(InventJournalTrans.ItemId);

          if(!inventTable.recid)

               ret = checkFailed("Item ID is not exist in table master item table.");

      }

      return ret;

    }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans