How to get field from other table?

Hello guys. I want to get field from specific record in table2 and put it, in field in table1. How to do that ?

Answers

  • SanderDkSanderDk Posts: 248Member
    Hi @sisko
    Try using a flowfield:
    https://docs.microsoft.com/en-us/dynamics-nav/flowfields
    This will show you data
    For help, do not use PM, but use forum instead, perhaps other people have the same question, or better answers.
  • MaaaxMaaax Strasbourg, FrancePosts: 14Member
    Oh oh oh! Not too much flowfield! NAV is a little bit shitty on this.

    Depend on what you want to do...
    1. You can use a variable calculated OnAfterGetRecord in your page, and use it like a field.
    2. You can use a FlowField.

    In the first case, you can see the value, but not filter/sort on it. But it will be the solution avoiding perf. problems. In the second, you will be able to filter/sort on it, but it will slow you NAV because the Query made in SQL is really shitty.

    I hope this will help you.
    I wish you a nice day.
    Maxime JUND
    Talent Business Solutions
    Technical Expert of Microsoft Dynamics 365 Business Central
    Website | Mail | LinkedIn
  • siskosisko Posts: 2Member
    I Used FIND('=') and worked. Don't know is it the best way. Thank you for the help guys :).
Sign In or Register to comment.