Richard,

I want to track employees and the education they are going through. These can be In-house or "out-house". I asume this is a many to many relationship? I have tables employee and education and a junction table employeeXeducation. A created a form employee with subform employeeXeduation. (like in your seminar with products and vendors). Is this the way to go? But, I must enter the education first and then asign it to an employee via combo box. I want to be able to pick the predefined education (which for example all of the employees are taken) but also enter a new one directly on a subform (for example, only one employee is taking it). Is there a way to do it without entering the education table or form itself?

Also, I didn't understand the self join answer regarding grading the employee. Can I create a selfjoin Grader (which is also an employee) and in the same table put field Is Gradable?

I am having trouble "translating" your courses to my specific needs.

Thanks a bunch

---

Richard Replies:

That's always a problem that I have... trying to "translate" a client's terminology into something that I understand. Sometimes customers come at me with specific terms and I have no idea what they mean or how they relate to one-another.

When you talk about employees and education, do you mean employees and CLASSES (are these distinct classes, or course regimens)? But yes, you should be able to do it with a simple form/subform. When you pull up the employee MAIN form, you should be able to just add records to the subform and the relationship between the two forms (parent/child) should keep everything straight.

If you are trying to add NEW CLASSES, then yes, you'll either have to add them first to the class table OR use a "not in list" event which is pretty tricky.

As far as your self-join goes, if you have PEOPLE, some of whom are students and some of whom are graders, but graders can also be students, then you could just use one table and have a Yes/No value "IsGrader" to identify those people.