The structure of my database is:
Accident Number, for every accident number I have many approachs, for each approach many vehicles and for each vehicle many seating positions.

I am having problems viewing of all this info on one form, as Access won't let me nest more than 2 subforms.

Can someone please advise me of a way around this without having to make 2 forms.

Thanks,

Rob

Sometimes the Form has limitations which are better seen by creating a query with all your linked options and then from there, drop in a Sub_Datasheet. Use color options to differentiate as well. Tools-Officelinks and drop wide ranging reports for analysis into Excel is also useful.

There are probably other suggestions.