General information
Category:
Forms & Form designer
>Any view (parameterized or not) will update its underlying table(s) if set up correctly. Open the view designer and go to the Update Criteria tab. Be sure you've checked the "Send SQL Updates" box (this is the usual problem when views won't update - it defaults to UNchecked). Then mark the fields you want to update, and mark the key field.
>When this is done, a view will save to the underlying tables by calling TableUpdate(). If your underlying tables are open and buffered, you'll have to update them AFTER updating the view.
How do i determine the key field? Does it have to be a unique id value?
Could you better explain that last part? I get from it that before i use the =Requery() that i should use TableUpdate (on the view?) I don't understand what you mean about updating the tables after updating the view. (tableupdate(view), then tableupdate(maintable) then =requery(view)?)
I'm sure by now UT'ers know that PBP trains developers by making vague requests and then pushing up the deadlines. Thanks again for all your help.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only