I am using a read only view for record navigation in a grid and bound controls are using the updatable view. Both views are parameterized. I requery the updatable view using the PK of the read only view like this;
>
>lcMst_PK=V_MASTERIDPARM.Mst_PK
>=requery(THISFORM.icMainViewAlias)
>
>So I should be able to requery the 'new read only' view in a similar manner eh? I'll have to give this a try and see what little framework grimlins await me.<s>
Excuse me, but I'm working on a very similar solution and I don't think that using two views would be a good idea. If I've understood it right you're using a read-only view with user-friendly fields for the foreign keys, and an updatable version (for the same main table) on a form. Right ?
If so, why don't you use a single updatable view for both the grid and the form ? You could set the grid as read-only, and leave the bound controls as they are, and you'd need to requery the view once for both modes. Wouldn't it be better ?? I understand that the use of the Join clause causes a certain loss of performance, but requerying the 'same' view twice isn't better at all...
Sincerely,
Andrea Brajuka