forms based on recursive entities

[kesmond]

I am modelling a grandparent/parent/child structure using recurseive entities. Querying the data is fine and easily find the grandparent for a child for instance.

My problem is developing a form to update details. As everything is one table [peiceOfWork], with a parent field to give hiearchy, I have to flick through each peiceOfWork to find the details I want.

What I want to be able to do is select a peiceOfWork by parent. The table peiceOfWork has a many milestones table therefore in total 3 levels are used. AS I understand it access forms only support 2 levels.

Any advice greatly appreciated

 

[JerryDennison]

Actually, you can do this in a form with subforms. Simply base each form on the same table. Link the first subform's master field to the main form's primary key and the child field to the subform's parent field. For the subform's subform (i.e. grandparent) link it's master field to the subform's primary key and the child to the subform's subform's parent field.