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)
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.
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?
Hi 
Yes if the feature were to be added, it would most likely be to the new cloud-based version of TimeXtender and not the legacy version. We plan on releasing a migration tool to help migrate projects from the legacy version to the new cloud-based version of TimeXtender. Please feel free to submit an idea for the table relations feature in the ideas section.
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.