Hello, you guys have been of great help lately! Here is my current
problem:

I have 2 tables. One is a recurring "import table" set up by FMP 11
(though I don't think that is relevant). The other table is the
"Primary table" for my database.

The "import table" has a number field in it. The relationship to the
"Primary table" has been defined based on one relating field (the name
of a record in this case).

I have a summary field that is a Total of the number field in the
import table.

Then I have gone to a layout using my primary table and have added the
field from the import table into a trailing grand summary. When I
look at it in list view, I see all of my records from my primary
table, but my trailing grand summary only displays the value for the
selected field.

I think I must need some sort of calc field that grabs all found
records, however nothing I have tried works.

Any thoughts?

On Apr 29, 6:45*pm, dc <damien... (AT) gmail (DOT) com> wrote:
I figured this one out, I figured I'd post my answer in case anyone
else has a similar question.

I had to change the table of the layout I was using to the "import
table" instead of the "Primary table". Once I did that, my trailing
grand summary worked just fine.