Reference qualifiers look simple until production users see the wrong records, or the picker takes forever to load. This post breaks down how Simple, Dynamic, and Advanced reference qualifiers actually behave at runtime, and how to choose the right pattern so your filtering logic stays secure, fast, and maintainable.