Thank you for your reply Richard.  I am going to purchase and review your recommendations below.  I have attached a condensed version of my three tables and the one of the relationships I am trying to establish.  I oversee the volunteers in Crown Point, IN at our clinic.  There are two types of volunteers in our Volunteer Transportation Network Program: Office volunteers who work in an office taking phone calls from Veterans and scheduling rides via our DAV (Disabled American Veterans) vans (donated to the Dept. of Veterans Affairs).  These volunteers have computer access, which requires computer training, orientations, second level of background check and a smartcard, which serves as an ID and is inserted into the keyboard for computer access.  The other other type of volunteer is a person who will drive a van from one of three locations in NW Indiana to the clinic.  They have a separate and relatively different processing track than an office volunteer.

I would like to tie the unique ID on the top table to one of the two tables below it with that number flowing to either the office volunteer table or driver volunteer table, but also based on one of the fields (type of volunteer: office or driver) choose in the top table.  If I select in this field "office" this record (Potential Volunteer table) would then tie into the record in the table office volunteer for that person.  The same would happen for a driver volunteer.

I hope this explains it better.  I do not know if it is possible or I may have to do a subtable to link the three tables together to accomplish this.  This relationship almost reminds me of the if then statements.