Summary

[Heathbo]

How do I get a summary from one table into another?

[-Queue-]

Summary fields are local to their defined table. Use a calculation field of Sum(relationship::numberfield) to get a total of related numberfields.

[Heathbo]

OK, bear with me please, So I have a calculation field in a table titled fillings. This field is the Sum(relationship::numberfield). After I create this field how do I link it to the other table titled Pies. What I mean is, do I create another calculation field in the Pies table? Or is it just a number field with no calculations on it? Then I create an = relationship in the relationship tab? I'm not totally new to relationships but this one is different than any of the others I've done. For one thing, I need the field in the Pies table to be a global. So I shouldn't have to create a join file, right?

Any help you can give is much appreciated.

[-Queue-]

I think I would need to see your file and have you elaborate on what you're trying to accomplish.

[Heathbo]

Thats just it I haven't started yet. I was just planning on what I need to do before I start. Ultimately I need to now how do I get a number thats in a summary (average) field into another table? The other thing is, in the other table this number has to be a global. I guess I could always copy and paste, but I'm sure there is a more elegant way of doing it.

Thanks.

[Heathbo]

I've attached a file of what I'm trying to do. Unfortunately I can't get it to work. I've also put comments into the file so you will know what I'm trying to do.

Example.fp7.zip

[-Queue-]

You need a couple of Cartesian relationships. Average(Info field) only applies to the current record's Info field. Using a Cartesian self-join, you can make an unstored calculation of Average(rel::Info field) give the result based on all records in the table. Similarly, you can use a Cartesian join between the two main tables and an unstored calc of rel::Average Field to pull the result to the other table. If you only need it for display purposes, then you don't need the calc and can simply put the related Average Field on your second table's layout.

See attached for changes.

Example.zip

[Heathbo]

Thank you so so much. I was pulling my hair out with this. I have never used a Cartesian relationship before. By the way, is there a way to put a round function into the Average Field calculation? That way I don't have decimals. Thanks again.

[-Queue-]

Sure, just use Round( Average(Ex1|Info field::Info field); 2 ).