I'm attempting a 2 page, page frame layout.

The first page holds fields of the 'one' table with a number of long fields that will the fill the top half of the page - the bottom half of the page is a grid with some fields from the 'many' table, most of the fields will need to be scrolled to be visible.

The second page holds all of the 'many' table fields laid out for easier data entry; with a few fields from the 'one' table displayed at the top to help identify the 'one' record that we're adding 'many's to.

Is this layout workable?

I'm puzzling of how best to use controls so user can easily add/edit the 'one' fields or add/edit the 'many' fields. I'd expect the next/prev/top/bottom buttons to manage the 'one' table with the 'many' along for the ride. As I write this I'm wondering if a child form that takes the place of page two might work better.

I'll have to manage key fields in the background.