I would like to show the main data on the top of my form in the Main form. Then I have a one to many relationship where I want to show the Many on the subform in a table format to select one of the many choices. I cannot get the subform "next record" to link to the ID in the Mainform. I need the subform to advance to the next id record not the next record.

Then use the main form record selectors.