AnsweredAssumed Answered

Relate two contacts

Question asked by deliciousapple on Jul 14, 2009
Latest reply on Jul 14, 2009 by deliciousapple


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.