AnsweredAssumed Answered

Value List of certain customers

Question asked by RobinBrowne on Feb 21, 2013
Latest reply on Feb 21, 2013 by RobinBrowne


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.