This may seem like an obvious question, but since I cannot find any documentation related to this, I thought I'd put it out there and see if I'm on the right track.
I've got several Local Views which I am using as prototypes until my client can fork over the dough to upgrade to a real server. Anyhow, I have paramterized all of these views and am allowing updates. A primary key (or keys) have been identified for each view. In order to add records to the base table I am bypassing the view and issuing a direct SQL insert into the table. (IF I simply add records to the view, the SQL update doesn't populate the key fields for me.)
Question #1: Is there a better way to do this?
Question #2: Will this work when these tables become remote?
Any and all advice would be much appreciated.