Man, this helped so much. This is what I started to try to do, but for some
reason I couldn't get the darn thing to work properly. Your step-by-step
instructions was just what I needed.

About the naming conventions, I unfortunately inherited this database, so
normally I would try to adhere to them, however, I'm afraid that if I change
the names of things, they wouldn't propagate properly. I've already tried
renaming various forms, tables, reports, and queries, and things ended up not
working, and I'd spend hours going back through trying to find places where
the changes didn't propagate.