Originally Posted by
Chevlion42
Thank you for posting this. I think your method might address a concern I've been researching and trying to figure out for months.
I'm building an Access 2000 file format database for a membership organization which is beginning a mentoring program (I started building it in Access 2003 but my office upgraded to Office 2007 a few months ago). The 3 key tables are Mentees (people requesting mentors), Mentors (people wanting to be mentors), and Mentoring Categories (subjects for which mentoring is available). What I've built so far is suitable for keeping track of the two groups of people and maintaining the list of mentoring categories. However, I also want to be able to search the mentors table and pull up possible matches for new mentees. Ideally, that search would also generate a report of any matches made.
The fact that your example creates a separate table where the search results are stored leads me to believe that it could be adapted to my database. Do you agree?
If your method isn't appropriate for what I'm trying to accomplish, is there another method I could use?
I would appreciate any advice or direction you might be able to offer. In the 6 months that I've been working on this database, your method is the closest to the kind of searching that I have in mind that I've been able to find.
Thanks again for doing your posting.
P S: I have attached screenshots of each of the 3 tables in my question above - Mentees, Mentoring Categories, and Mentors - to my reply posting.