do not type data manually in Text field on form???

kishi_g

Is it possible The person do not enter data manually in Text field on form.
he use the lookup button on that text field. he selects the data through lokup button only.






Thanks & regards,
Kishore.

DenSter

Have you tried setting the field to non editable? I don't know if that leaves the lookup button, but that's what I would try first.

kishi_g

Hi Denster,
Thanks for ur reply. If we set the property editable as No then we can not select record in the lookup table. the lookup data will not come to the text field if it is in non editable mode.






Thanks & Regards,
Kishore.

McClane

I think you will have to set it to editable=no and put some code in the OnLookup-Trigger, e.g.:

if form.runmodal(0,ItemCategory)=Action::LookUpOK then
  "Item Category Code":=ItemCategory.Code;

kriki

You can put an error in the OnValidate-trigger of the field. And you can put this code in the OnLookup-trigger of the field:

recTheTable."Primary Key Field" := "Your Field On The Form";
IF FORM.RUNMODAL(0,recTheTable) = ACTION::LOOKUPOK THEN BEGIN
  VALIDATE("Your Field On The Form",recTheTable."Primary Key Field");
  CurrForm.SAVERECORD;
END;