>>>Does anyone know how to set focus to a record that you append to a grid? I am using an Add button with APPEND BLANK and then myGrid.Setfocus().

I usually just do an append blank and then setfocus to the grid, and I'm on the blank record. For a simple example:

append blank
_screen.forms(1).grid1.setfocus()

took me to the bottom of the grid (and the blank record).
Is there something in how your tables are related that's complicating things?