Relationships based on calculated values

[AKSHUN]

I'm trying to create a many to many relationship with keys that are calculated values.

I have a table that contains a fair number of fields that includes things like times, dates, and ID numbers. I need to define fields that will keep a summary of things like the total of a specific record in a given month and year.

So my relationship is set up like this.

Relationship_1::

Table_Instance_1 Table_Instance_2

YearOfDate = YearOfDate

MonthOfDate = MonthOfDate

ID = ID

The YearOfDate and MonthOfDate fields are calculations based on the date of another field.

YearOfDate is defined as year(job_date)

MonthOfDate is defines as month(job_date)

What I need to do is define a field so that it will automatically total the values in another field for an entire month.

If I create a definition like this "sum(Relationship_1::Field)" even though the field in question has a lot of data in it, there is nothing totalled by the field.

Do relationships based on calculations just not work?

[transpower]

Put the sum field in the table for the records you're summing. Then display this field in a layout for the summary table. If the two tables are properly linked, you'll get the answer your seeking.