I need a value list based on the results of a find
I have 3 tables, People, Companies & Phone Numbers. Each company picks an available phone number when they sign up. The number is then assigned as either, voice, fax or modem. When the clients sign up I need to have a list of available numbers, show up in a value list. I can get all the numbers, but what I really need to know is which ones have been previously assigned. I do have an "available (yes/no)" field in Phone Numbers, so the information is there. I can create a find to show me only the available numbers, this result is what I need to have show up in the Value List.
This data is then saved in the Phone, Fax, Modem field in the Company table. Is this possible? Keep in mind, I just started with FM 2 weeks ago.