Refresh Does not update the PK on a newly address Record Specially if you are using the same Alias. I sugest use Store Procedure that insert a new record and return the PK (Identity). then you can use it i Requery in the Remote view with Parameter.As you mention you have a large database . so use always Parametered View.
Roses are #FF0000 Violets are #0000FF all my base are belong to you