3 Replies Latest reply on Jun 3, 2014 5:02 PM by bekenstein

    Need Help Sorting Multiple Roles of Individuals without Duplicating Data Entry


      I'm developing a database for a small social service agency. People who receive services from the agency may also become mentors to other clients. I have created a table to store all information on clients and would like to display a portal on each record of showing clients that are available to be mentors and then selecting them and listing them as part of the record of the client receiving their services. I have played around with the self-join concept, but have not been successful in getting that to work. Any suggestions are appreciated.