4 Replies Latest reply on Jul 27, 2009 4:09 PM by etripoli

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

    canexsu

      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.