AnsweredAssumed Answered

I need a value list based on the results of a find

Question asked by canexsu on Jul 27, 2009
Latest reply on Jul 27, 2009 by etripoli

Title

I need a value list based on the results of a find

Post

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.  

Outcomes