good day everyone
Here's a simple scenario of what I'm trying to do.
I have a form for inputting company departments. Nested at the bottom of
that form is another form for inputting the employees that are members of
that department. Each works by itself. I have the one to many relation****p
in place between the department and the employee tables but I can't seem
to
figure out how to set up the forms properly so that as I navigate (both
forms has "Navigation Buttons" set to yes) through the departments the
employee form only displays the employees that belong to the department
that
is currently populated in the parent "Department" form.
So, say I have 5 departments, I mouse down on the department form and can
navigate through the 5 departments. The employee form at the bottom of the
department form populates with say the first record returned based on the
department that is currently displayed. If I stop on the 3rd department
and
mouse click on the employee form I want to be able to navigate through
only
the employees belonging to that department. I'm currently have an "On
Change" event on the Department ID form element and have been trying to
use
that as the object to reset the query for the employee form. I can't seem
to
get that to work.
I'm quite certain that I'm just not applying my commands properly so I'm
wondering if someone might be able to walk me through getting this to
work.
Thank in advance
Bill
