AKSHUN Posted February 3, 2005 Share Posted February 3, 2005 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? Link to comment Share on other sites More sharing options...
This topic is 6621 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now