Hi Nav masters,
I want to know is it possible to create flowfield from 2 different table?
Or create it by codes instead of by properties.
I want to create a field "Item Tracking Exist" <boolean> to show on sales line, so that if this line already have Item Tracking, it will shows.
I create a flowfield to check from table Reservation Entry.
But then there's a problems when i post ship my sales line. The Reservation entries move to Tracking Spec table. Thats why i need my field to check both table.
Is there any way to do this?
Thanks in advanced
______________
Regards,
Steven
0
Comments
1.)
You can then display the result on form like
But with this solution you can't filter on this field.
2.)
If you need to filter, you can create a new field, which you fill out in the post. codeunits.
With both solutions you must add the drilldown through code.
3.)
Or, you create a new linked table which is based on a sql view. Than you can also filter and you can create a new flowfield which is based on the new sql view ;-)
The easiest way is 1.
Regards
Those of you who think you know everything are annoying to those of us who do. -
David Brent
I know what you guys mean.
Thanks for the suggestion.
I'll create 2 flowfields and call the function to check both flowfields on my form.
Regards,
Steven