I am setting up a table relation where the tables join based on a date range (see screenshot below)
In setting this up in TimeXtender, I noticed that I can only set this up on the lookup field and not as the default relation between the tables.
Does anyone know of a way this can be setup on the default table relation? Or can we had as an enhancement for TX?
(NOTE: I have edited the table names and columns for this post)
Best answer by Thomas Lind
Hi Kerry
No, it is not possible to set this as table relations.
It would be a new feature if it needed to do this.
That said, I have a guide regarding joins using greater and less than operators.
The guide is about exchange rates, but it can be used on all tables where a date range is necessary to get the data.
+5Hi Kerry
No, it is not possible to set this as table relations.
It would be a new feature if it needed to do this.
That said, I have a guide regarding joins using greater and less than operators.
The guide is about exchange rates, but it can be used on all tables where a date range is necessary to get the data.
Thank you for sending this over, I think this could work for what I need. I currently have something similar already setup but for MTD Customer values so can extend this.
Since I am working with an on premise (legacy) version of TX, if this enhancement ever was added, we would need to migrate to the new Cloud based TX. Is that right?
+5Hi
Hi
I will add my comments from this post to the ideas section to see if we can add this as a new feature.
A migration tool sounds exciting! I will look out for that release (:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
