Forum Discussion
Resolver Icount rows by month without creating relationship
I believe you can create a virtual relationship bewteen tables using the TREATAS function (never used it myself; so far have managed with inactive relationships and USERELATIONSHIP). Sorry I can't be of further help, but might be worth scouting the internet.
Try here for example: TREATAS by enterprisedna.com
Resolver IAs I mentioned in my first post, is there a way of doing this without creating a relationship, because this screws up the calculations in my original table. Even creating a relationship and leaving it inactive will screw up the calculation
Or do I just need to figure a way of calculating my orignal table differently?
Responsive ResidentThat is really strange that it is messing up your table when you leave it inactive. That is what I would do.
Can I assume you are leaving the relationship with the Task Completion Date active when you create the inactive relationship with the Due Date?