Recursive form

M

Miaplacidus

I have an employees list. The list includes a field for
who the employee reports to. I have a form that shows each
employee with a subform which shows all of his
subordinates. Both the form and the subform are based on
the employees table.

The employees subform shows the name of the subordinate
his title and who he reports to. The employees subform has
an extra row in it that begins with an asterisk. In
the "Reports to" column of that row the field is filled in
with the words EmployeesList, which happens to be the name
of the form.

How casn I make the "EmployeesList" entry go away and how
can I make the default entry for that field in the subform
to be the same as the "Name" field in the parent form?
 
Top