Select order without using form

imurphy · 2008-06-18

Is there any way to use a list form such as '45 Sales List' as a picklist to select a sales order reference? ... only using code and not a bound field?

This is the form which pops up when you press F5 from the order window.

I'd like to add a button to a form which the user presses to select an order. I then pull some info from that order into the current form.

Reusing form 45 would seem to make sense - but only if there was some way of getting a return value from it.

Ian

kriki · 2008-06-18

Something like this:

recSalesHeader.RESET;
recSalesHeader.SETCURRENTKEY(....); // the key you want
recSalesHeader.SETRANGE("Document Type",recSalesHeader."Document Type"::Order);
recSalesHeader.SETRANGE or SETFILTER : other filters if needed
IF FORM.RUNMODAL(FORM::"Sales List",recSalesHeader) = ACTION::LOOKUPOK THEN
  "Some Field" := recSalesHeader."No.";

BTW : this codes is for the OnLookUp-trigger

imurphy · 2008-06-18

Thanks, I think that makes sense. I'll have a go an see if it works for me.

Select order without using form

Comments

Categories