AnsweredAssumed Answered

Relate two contacts

Question asked by deliciousapple on Jul 14, 2009
Latest reply on Jul 14, 2009 by 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. 

Outcomes