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.