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.