flowfield problem

herman

Hi all,

I have two flowfield in table "Sales Invoice Line"
1. "edition" linked to the "Sales Invoice Header" table where this field is added.
2. "name" linked to the "Salesperson/Purchaser" table.

In the "Sales Invoice Line" table all flowfields are working fine.
When I create a report with those two flowfields in the "Sales Invoice Line" body, only the "edition" flowfield is displayed and not the "name" flowfield". This field "name" remains blank.

Thanks for helping me out.
Herman

DenSter

Have you tried doing CALCFIELDS(Name)? Only on forms do flowfields just display, anywhere else you have to calculate the value before you can use it.

HTH

herman

I have tried to use the Calcfield, this doesn't help.
The "edition" flowfield is printed correctly in the report, and its the same type as the "name" flowfield so I don't understand what's going wrong.

Thanks for your help

borsicsj

Haven't you used a flowfield in the definition of your new flowfield?

DenSter

herman wrote:

I have tried to use the Calcfield, this doesn't help.
The "edition" flowfield is printed correctly in the report, and its the same type as the "name" flowfield so I don't understand what's going wrong.

Thanks for your help

If you add the field to the Sales Invoice form to see if it gets populated correctly on the form? There may be a problem with the link.

I'm thinking that the Salesperson Code is not on the Sales Invoice Line, and you need that Code to lookup to the Salesperson Name field.