2 Replies Latest reply on Feb 21, 2013 11:44 PM by RobinBrowne

    Value List of certain customers



      Value List of certain customers


           I'm new to FM and have been unable to figure this out for myself - it's probably quite obvious and I'm very grateful for anybody's assistance.

           I have a table of my customers' information. One of the fields reads either "yes" or "no" for whether they are a customer for my design services (which most are not). On another table (Projects) there's a field to select the client for each project. I want that field to have a drop-down from which I can select only my design customers.

           I can't seem to find the right combination of field relationships etc to result in that value list only consisting of my design customers - I either get them all or <no values defined>

           Many thanks to anyone who can direct me to the right solution.