AnsweredAssumed Answered

Is this Relation possible?

Question asked by ChristofferRexen_1 on Jan 24, 2017
Latest reply on Jan 25, 2017 by philmodjunk

Hello everyone,


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!