How to get field from other table?

sisko

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

SanderDk

Hi @sisko
Try using a flowfield:
https://docs.microsoft.com/en-us/dynamics-nav/flowfields
This will show you data

Maaax

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.

sisko

I Used FIND('=') and worked. Don't know is it the best way. Thank you for the help guys .