Flowfield formular using several table relations

AleSlammer

Hi

I have a field in the job task table where I want to sum All the line amounts from the related job planning lines from the job planning line table. But only for hse job planning lines where the G/L Account is Income Statement.
The thing is there are two tablerelations involved...job task to job planning line and job planning line to G/L Account. Is this possible to do in a flowfield formular ?

matttrax

In short...no.

You could add a field to the Job Planning Lines that gets filled out when the G/L Account is validated to say whether it is income statement or not.

AleSlammer

oki, that is also the solution I have picked, not that I like it since it requires a tough data convertion