I have a one to many parent-child database setup in which I am trying to use a 4 page pageframe to allow all of the input into the parent and the child.

One of the four pages includes information for both the parent table and the child table. I want to leave the ability to change the parent table on the top of the page (I actually have it on the pageframe so it shows up on all four pages) and then set up a group of command buttons which will allow me to move to the next and previous records within the child table while leaving the parent unchanged.

Any suggestions on how to accomplish this would be appreciated. I seem to be having trouble getting my parent table to not be the one changing.

Thanks

Todd