AnsweredAssumed Answered

Is it possible to create a relationship from a constant to a variable value?

Question asked by Mike Feeney on Jun 16, 2017
Latest reply on Jun 16, 2017 by user1069

I want to be able to create a portal that shows records with a balance greater than zero. A filtered portal takes too long to load when there are thousands of records, so I was wondering if there was a way to create a relationship that would accomplish the same task. In my solution, Table A would have a constant field (presumably in this scenario it would have to be some sort of calculation) that would match against a balance due field in Table B. Is this possible? Note that in some records there will be a value less than zero (a credit), for which I would want a separate relationship to display refunds owed to customers. Thanks.

Outcomes