Adding related fields

[Glasstream]

Ok, hope this is an easy question.

I have a table called BBP and a table called AW and a table called RS and also MR.

All the tables have records on them and I have created a field called records that uses a calculation Get (TotalRecordCount) and it displays the total number of records and updates when more are added.

I then created another table called Title, with a relationship to all the others and put the records field from each of the other tables onto this table.

So I have all the totals from each of my tables showing up on the title table and I try to create a calculation field to add up the 4 related fields (like - Sum (BBP::records; AW::records; RS::records) etc.. but does not work for some reason. I am new and just figure I am missing something easy.

Any thoughts?

Thanks in advanced.

[RalphL]

Sum (BBP:records; AW:records; RS:records) should be Sum (BBP::records; AW::records; RS::records) Double colon between TO and Field.

[Glasstream]

Sorry, I wrote it down in the post incorrectly, I do have double colons between mine, but still nothing is showing up in the total.

[Vaughan]

Should it be

Sum ( BBP::records Sum ) +Sum ( AW::records ) + Sum ( RS::records )

[comment]

Should it be

Sum ( BBP::records Sum ) +Sum ( AW::records ) + Sum ( RS::records )

No, because Sum ( BBP:records ) will return 30 if there are 10 records in the BBP table and 3 of them are related.

Surprisingly, Sum ( BBP::records ; AW::records ; RS::records ) does "work", but ... if the result means anything, then I suspect all those records should be in a single table to begin with.