Flowfield in form 3.01A

shogan@mila.ie

Heya all,

Using a relic, I know!

Wondering if I could set up a flow field in a form.

I have a Document No. field based on Sales Orders in the table that this form is based on.

What I want is a field on the form that looks up the Document No. on Sales Order headers and bring the Customer No. field back into my form as a type of look up field.

Looks really complex, wondering if I could get a general idea of how to do this?

Or would I need to perform some programming?


Thanks to all, great site and keep up the good work!

SHogan

kriki

To create the flowfield in your table:
-create a field "Customer No." as code20 and the following properties:
-FieldClass=FlowField
-CalcFormula=Lookup("Sales Header"."Sell-to Customer No." WHERE (Document Type=CONST(Order),No.=FIELD("Document No.")))
-Editable=No

And that's it.