Hi everyone,

I have a databas that has Invoices and PO's. They are in the same table. When a user clicks on the "Invoices" button, the script goes to the all the records that are marked as Invoices, and the same with PO's. I have a constant field marked as "Invoices" and one marked as "PO". I have a relationship between the constant field and a field called "Invoice_PO". (A "New record" script creates the new record and propagates this field with "Invoice" or "PO" depending on the script parameter). I have two fields called "Total_PO" and "Total_Invoice". What I am trying to do is have this field on their respective layouts and show the total of each. The current calculation for each is:

get(TotalRecordCount) "Evaluate this calculation from the context of" the relationship between the constant and the Invoice_PO field.

Shouldn't this work? I can't get it to.

Thanks

Any help would be greatly appreciated

Hmm. Get(TotalRecordCount) returns the number of records in a table. Did you intend to use Get(FoundCount)?

Thanks for responding so quickly,

Heres the thing. I have a found count field so if someone needs to find invoices from a certain date they can. But I still would like them to have a field telling them the total number of invoices. I want to eliminate the status area and set up my own. with the found count and total count.

In that case, Count(PORelationship::serial) and Count(InvoiceRelationship::serial) should do it.

That worked perfectly. I had my relationship backwards and that was screwing me up. Thank you so much.