Filter lookup flowfield.

Crunch

On T27 Item a new field is added: MyField code 10
on T37 Sales Line, I'm trying to make a lookup flowfield to MyField.
I copied the field, and set it as Flowfield, lookup.
Lookup(Item.MyField WHERE (No.=FIELD(No.)))

How can I also filter, so I only get the value, when Sales Line.Type = Item ?
My own guess is the OnLookup trigger.

EDIT:
Onlookup didn't work for me.
Tried this:

IF Type <> Type::Item THEN
MyField := '';

A trigger on the form perhaps?

Luc_VanDyck

Crunch wrote:

How can I also filter, so I only get the value, when Sales Line.Type = Item ?

You can't use a Condition in a FlowField, as you can with the TableRelation-property.

MBerger

If the client doesn't want to filter or sort on your new field, you could make it a function in T37 instead of a flowfield. Then use that function as the sourceexpression on the form.

Crunch

Thank you for your answers.

At the moment I do the following on the form on the OnFormat trigger of the ctrl.

IF Type <> Type::Item THEN
  Text := '';

It works, but still feels somewhat "wrong".
Might go with the function.

Savatage

Why the OnFormat Trigger? Or were you just guessing where to put it?