Forum Discussion
JacobJacob
8 years agoQrew Cadet
How about just making table B a connected table and filter only the records where the effective date is on or after today. You could then set it to refresh every hour. Then only the records that have an effective date past today will pull into that table. There are cons to using a connected table but this seems simpler than managing four tables.
RichardPfister
8 years agoQrew Cadet
Thank you! I have not learned about connected tables yet but it certainly seems like a better solution. I'll tinker with this approach and post back.