1 Reply Latest reply on Mar 17, 2011 8:18 AM by philmodjunk

    How to Create a Drop Down from a specific set in a field?

    AlanOlson

      Title

      How to Create a Drop Down from a specific set in a field?

      Post

      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?