FlowField Lookup option

idonav
idonav Member Posts: 31
in NAV Three Tier
Hi,

I would like to do a standard FlowField Lookup to another table, the field that I would like to lookup is of the datatype option. This means that I have to specify an OptionString for the field where I am doing the lookup. The OptionString then replaces the actual lookup value.

How can I do a proper FlowField with a lookup to an option field?

Best Answer

  • idonav
    idonav Member Posts: 31
    Answer ✓
    I solved it by creating a function getting the value in OnAfterGetRecord, this works perfectly fine, though, I'd still like to know how to solve the flow field. Feel free to keep on replying.

Answers

  • SuD
    SuD Member Posts: 102
    You Should filter record value from target Table...Or you can do this in another way..
  • idonav
    idonav Member Posts: 31
    Still tells me to fill in the options string and as soon as I do that, it overrides the lookup field.

    What other solutions do you suggest?

    (I know I can just do it in code but I don't see why a flowfield and a lookup should not work.)
  • idonav
    idonav Member Posts: 31
    Answer ✓
    I solved it by creating a function getting the value in OnAfterGetRecord, this works perfectly fine, though, I'd still like to know how to solve the flow field. Feel free to keep on replying.

Categories