Flow Field to Lookup Flow Field

johanna

Dear all,

Is it possible to create a new field with flowfield field class to lookup flowfield in other table?
I want to add new field "Qty On Prod Order" in Req Line table to lookup "Qty On Prod Order" in Item table. Is it possible to do this? Thank you.

SPost29

No you cannot create a flowfield to a flowfield

In your case you need to create a flowfield on Req Line that looks at the same table (i think Prod Order Line) as the item card.
The challenge is does Req Line have all the fields necessary to create the flowfield.

OR

The other way is to calc the item flowfield on the Req Line form and assign it to a column
The challenge with this is that then you can't filter on that column.
Hope this helps
Steve

johanna

Hi Steve,

Thanks so much for your suggestion.. I think I will try the second choice first.. ehehhehe.. Thanks !

johanna

Hi Steve,

I have tried the second choice and it's work
Then I think there is a third choice : add new field in Req Line that is populated as Qty On Prod of Item when validate Item No in Req Line
But, I want the new field in Req Line has drop down.. So, I choose your first option.. Thanks !!