I want to show a relationship in Microsoft Access made database. I am making a Member Profile Database.
What I want is this: When I enter profiles: for instance Me and my daughter. One field is labled Child's Name and I will put my daughters name in there. Done, then I will enter my Daughters profile and another field will be labled "Parent", there is where I put my name. At the end, I want to be able to open my profile and be able to click in the Child's Name field and it will bring up my daughters profile and then I can clik in the "Parents" field and it will come back to me. Can this be done in Microsoft Access? I am just learning about access and building databases.