How to Create a Drop Down from a specific set in a field?
I am trying to create either a Drop Down list or an Auto Complete list in Table 2, populated from a field in Table 1. My problem is that I only want to display a subset of values from that field. Specifically, I have a list of client names in Table 1. I only want to have the 'Active' clients displayed in my drop down in Table 2. There is a separate field in Table 1 that designates either Active or Inactive status. Suggestions, please?