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?

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.