Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Performing matches between Access 2003 tables?

 
   Database Forums (Home) -> MS Access RSS
Next:  JOIN FOR FREE- TO FIND GERMAN FRIENDFINDER + INDI..  
Author Message
Chevlion42




Joined: Apr 20, 2011
Posts: 1



(Msg. 1) Posted: Wed Apr 20, 2011 1:08 pm
Post subject: Performing matches between Access 2003 tables?

I am designing a database for a group which will match mentors and mentees. There are two tables - Mentors and Mentees – which call MentoringCategories, the list of mentoring subjects.

My major problem is this: How can I make the database generate matches between mentors and mentees? For example, Abby needs coaching on expense reports. Freda has 15 years of experience and is willing to help anyone with expense reports. I want to enter Abby as a new mentee and search the Mentors table for anyone who could coach her. How can I perform that search? I also want to save any matches for future reference.

My minor issue is this: I want to set up the mentors table so each mentor could select multiple categories for which they would provide coaching. How can I do this and store each mentor's multiple choices (if any)?

 >> Stay informed about: Performing matches between Access 2003 tables? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
'Insert Object' in Access 2003 removed from ribbon in Acce.. - I understand that Insert: Object has been removed from Access 2007, and I should be able to right click in the object field and insert that way, yet I am unable to. I do not get an error message, but right clicking does nothing. I found a message..

Sort form datasheet attempt crashes Access 2003 (error 345.. - 'add one textbox to form1 with Control Source property = ID 'copy/paste the form_load code below: 'Then open the form and then attempt to sort the datasheet 'crashes 2003, error 3450 Access 2007 - I can't find much info on this... - Can someone explain..

Access 2003 OLE communication error - locking up Access - MS Access is totally broken on my machine, whenever I attempt to open an existing database or just open the bare program I always get the error message "A problem occurred while MS Office Access was communicating with the OLE server or ActiveX....

Errors when opening Access 2003 file in Access 2007 - I have run into several errors when trying to open an Access 2003 file in Access 2007. The first error I receive is when I try to open the database file. “An error occurred while loading ‘ReportFileName’. Do you want to continue loading the....

Access 2003 - Hi I have a folder called “pict” in C drive. The folder contains people pictures and the pictures name is the ID of the person’s in the picture. I have a form in access 2003 that shows me a person details.(name, family, ID etc...) I need to see i...
   Database Forums (Home) -> MS Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]