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
View original
+5
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?
+5
Hi
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
