AnsweredAssumed Answered

Relationship with multiple intervals

Question asked by larsheise on Feb 27, 2013
Latest reply on Feb 27, 2013 by Mike_Mitchell

I know I can construct a find where I find records all the records in a table that as an example have id’s within the range of 1000..3999 and new find 5000..5999


But is it possible to create a relationship that from another table shows the same records in a portal ? ( I need the sum of another field in those related records )


Or if not is it possible to construct a calculated field with an Execute SQL statement that does the same ?