2 Replies Latest reply on Jul 14, 2009 8:22 PM by deliciousapple

    Relate two contacts

    deliciousapple

      Title

      Relate two contacts

      Post

      I have a Clients table, that holds basic contact info.

       

      If the client happens to be a child, I create another record for the parent (the parent might have different contact info, i.e. the parent might live at a different address).

       

      I would like to show the parents name on the child's record and visa versa (show child's name on parent's record)

       

      So some how I need to relate two records to each other, when the records reside in the same table.  

       

      Finally in my New Client Report, I need to show the child client's contact info and the parent's name and address (which might be different from the child's address)

       

      thank you for any help.