So working on a DB, in which a client has asked me to - maybe / maybe not - set up, at specific relationship which I am still fiddling with.
Two tables, "Customer" and "Policy"
The client wants, from "Customers" with a portal, to see every active policy in the "Policy" tabel with a portal, based on "InPowerDate" (Date field), but from the same relationship also omits every policy, where "EndDate" (Date field) and "TerminationDate" (Date Field) is ≤ to Today ( Get ( CurrentHostTimeStamp ).
The client will in many cases put a future date into "TerminationDate" and I might have screwed it up a bit, by using two different fields to accomplish the relation, I might only need "InPowerDate" and "EndDate"
The problem is, when the client is putting a future date into the "EndDate" field, in which the criteria for the relationship is no longer met and thereby omits the actual policy.
So, to sum up -- Show Active Policies, even when the client have entered a future "EndDate"
Please let me hear you're thoughts, dying to get his one solved!