Flowfield Lookup Problem (Service Invoice Header)

carl

Dear All,

I did a new flowfield "Amount" in the "Service Invoice Header" table and linked it with "Service Invoice Line". The flowfield returns the correct values however on pressing the lookup symbol the following error is displayed:

'The specified table (Service Invoice Line) is different from the table the form uses (Service Line).'

I rechecked the calcformula im giving the "Amount" field in the table and its something like this:

Sum("Service Invoice Line".Amount WHERE (Document No.=FIELD(No.)))

Any ideas?
Thanks.

klavin

The LookupFormID is set wrong on the Service Invoice Line table. I just checked my 5.0 SP 1 US ver.

Table 5993 (Service Invoice Line)
-LookupFormID: Service Line List
-DrillDownFormID: Service Line List

Form 5904: Service Line List
-SourceTable: Service Line

Might need to make a new form for Service Invoice Lines and change that LookupFormID on Service Invoice Line table.