Sorry, Allen, I obviously haven't explained my requirements clearly enough
or more to the point I haven't understood your suggestion properly. I thought
when you mentioned members that you were referring to members of the
organisation who aren't necessarily leaders, but as I don't have to keep
records for them I wrote my reply to you accordingly.

1) Yes I do need the mentor/mentee. So I need to know how to include that in
the database. I didn't quite understand your explanation of how to achieve it
though. I would be grateful if you would explain it again for me. As I said
I'm sorry for being so dense. Which table do I have to place the
mentor/mentee fields and the "relates to

2) Yes I am interested in the training of the leaders...but the training is
separate to the mentoring. The training is conducted by the state
organisation, whereas the mentoring is done in the Region by fellow leaders.
The leaders are required to have a Guiding Partner (mentor) as they work
through their modules. So the name of the Guiding Partner is tied in with
modules (qualification table) rather than with the training courses.
Obviously the complicating factor is that each leader can also be a Guiding
Partner, but not all leaders are.

3) I don't have to keep any financial records in this database, so don't
have to allow for any donations or payments.

3) I understand what you are saying about the training courses being held on
several occasions and the leaders only attending one of those. Getting that
sort of list might not be possible, so could I achieve the same effect by
having a course name field and a date attended field?

4) How can I trigger an "alert" for when a leader's appraisal is due
(required every 3 years by to maintain their qualification).


From my reading of the help file, I will have to set many-many
relationships. Is that correct? If so, how many extra tables will I need to
include if any?

Thanks again,
Anne





"Allen Browne" wrote:

The mentor/mentee suggestion was something I assumed you needed to do, from
your original post. If you are only tracking the leaders, then recording who
is mentoring whom is probably irrelevant.

Also, if you are only tracking leaders, perhaps it is only the training of
leaders you are interested in. Similarly, if you are only tracking leaders,
then it's only donations from leaders and payments authorised by leaders
that you are interested in.

Hopefully the information about enrolling leaders in an instance of a
training course (not the course itself) was useful.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.