Question about lookup

tompynation
tompynation Member Posts: 398
edited 2008-08-20 in NAV/Navision Classic Client
How can you make a user allways use the lookup for a field?

For Example,

Take the sales order, you have the 'sell to customer' field.
The users should allways use the lookup and shouldnt be able to fill in a customer number by just typing it

Answers

  • garak
    garak Member Posts: 3,263
    why the user should't fill th field :?:
    If your employee knwos the customer No. or his name why he could not inser't this ? I doesn't understand this ..... my customers are very :evil: if they ever must lookup and could not insert the number.
    But if you salsorder is only an example ;-) you m,ust do following:

    Field Editable = No.

    Field - OnLoockup() Trigger
    Here you put your source to fill the field after lookup. <- How this is to develop, you know. See the answers for your other questions for lookup .....

    Regards
    Do you make it right, it works too!
  • idiot
    idiot Member Posts: 651
    This is done probably to prevent carelessness due to laziness to type in the full Customer No....
    eg
    2 customers, aaa, aab
    user types a, aaa appears when in fact aab is required
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • tompynation
    tompynation Member Posts: 398
    well, the sales order was just an example...

    I need this because i fill up an extra variable in the OnLookup:


    Productcode - OnLookup(VAR Text : Text[1024];) : Boolean
    lv_Recept.RESET;
    IF FORM.RUNMODAL(50019,lv_Recept) = ACTION::LookupOK THEN BEGIN
    Productcode := lv_Recept.ReceptCode;
    ReceptID := lv_Recept.ID;
    StandaardProductie := lv_Recept.StandaardProductieHoeveelheid;

    And then i use this ReceptID in the Onvalidate trigger

    Productcode - OnValidate()
    lv_Length := STRLEN(Productcode);

    IF lv_Length > 0 THEN BEGIN
    CurrForm.POProductFormuleSub.FORM.VISIBLE := TRUE;

    CurrForm.POProductGrondstoffenSub.FORM.ClearTempTable;
    CurrForm.POProductGrondstoffenSub.FORM.FillTempTable(ReceptID,FALSE); CurrForm.POProductGrondstoffenSub.FORM.VISIBLE := TRUE;
    CurrForm.UPDATECONTROLS;

    So i needed to be sure that the user has used the lookup

Categories