3rd Level Subform Problem

[Guest]

I have a form which includes one main form with nested subforms - subform and
another subform within that subform.

The data in my main form and subform is fine. When I enter data in the
nested subform it repeats it's self for each record in my 1st subform.

The database is used to keep track of Employee Transfer Requests and all
activity surrounding the process.

The main form consists of Employee's name, number, etc. (basic employee info)

The 1st subform (Transfer Request Info) of the main form consists of the
employee's number and Transfer Request information. There might be one or 10
records per employee.

The second subform (Notification Info) is nested within that Transfer
Request Info subform. That form records correspondence between my department
and the employee. There might be one or 10 records per Transfer Request, per
employee.

I have linked the subforms by a field called employee number. I have tried
switching the relationships and switching the linked fields but nothing is
working.

Does anyone know how to solve this problem?

Thank you for your time!

 

[Dirk Goldgar]

I have a form which includes one main form with nested subforms -
subform and another subform within that subform.

The data in my main form and subform is fine. When I enter data in the
nested subform it repeats it's self for each record in my 1st subform.

The database is used to keep track of Employee Transfer Requests and
all activity surrounding the process.

The main form consists of Employee's name, number, etc. (basic
employee info)

The 1st subform (Transfer Request Info) of the main form consists of
the employee's number and Transfer Request information. There might
be one or 10 records per employee.

The second subform (Notification Info) is nested within that Transfer
Request Info subform. That form records correspondence between my
department and the employee. There might be one or 10 records per
Transfer Request, per employee.

I have linked the subforms by a field called employee number. I have
tried switching the relationships and switching the linked fields but
nothing is working.

Does anyone know how to solve this problem?

Thank you for your time!

What is the RecordSource for the lowest-level subform? It sounds as
though it may be based on a join of the intermediate subform's
recordsource table with the table into which the lowest subform should
be storing its data.