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

    Relate two contacts



      Relate two contacts


      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.