Question about lookup

tompynation

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

garak

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

idiot

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

tompynation

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