>I know the definitions of Seek and Upper(), but what is seek looking for; i.e. using to find "where it's supposed to be"?
>

It's looking for the correct entry in the Keys.Dbf for the table that you are inserting to. That's how it determines what the next key is.