In my experience with 1000+ database, the need to do that type of workaround is due to to a less that optimal database design. I have never had to do that with a properly normalized database.
Boyd Trimmell aka HiTechCoach
Microsoft Access MVP -2010-2015
Programming: Nine different ways to do it right, a thousand ways to do it wrong. Binary--it's as easy as 1-10-11