Flow Field to Lookup Flow Field

johanna
johanna Member Posts: 369
edited 2011-06-17 in NAV/Navision Classic Client
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.
Best regards,

Johanna

Answers

  • SPost29
    SPost29 Member Posts: 148
    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
    johanna Member Posts: 369
    Hi Steve,

    Thanks so much for your suggestion.. I think I will try the second choice first.. ehehhehe.. Thanks ! :)
    Best regards,

    Johanna
  • johanna
    johanna Member Posts: 369
    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 !!
    Best regards,

    Johanna

Categories