How to create a flowfield from 2 diffrnt table?

selece28 · 2008-09-12

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

garak · 2008-09-12

possible only with 2 Flowfields.
1.)

You can then display the result on form like

Boolvariable := FlowField1 or FlowField2;

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

mjrogers · 2008-09-12

I would create two flags and then either show both, or on the form code it so that a global boolean is true when either flowfield is true, and display that in the subform.

selece28 · 2008-09-12

Ok garak and mjrogers
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.

How to create a flowfield from 2 diffrnt table?

Comments

Categories