record navigation (1 Viewer)

[PhilC]

I have a one to many database with 2 subforms. I can set up navigation to scroll each(many to one) record, but I want to scroll through the main set so I skip over the sub records. My database is set up so I have a reference(area) field to many address fields, and each address field has many asset records. What I would like is to scroll through the reference(area). Is this possible, and if so can anybody tell me how?

 

[lwhite]

Look at Northwind example form Custom Orders. It has 2 subforms with a many to 1 relationship. It maybe helpful to you.

 

[PhilC]

Thanks for that, I see I can modify that to fit my needs.