General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
The controls on your form should be bound to the view fields. APPEND BLANK when inserting a new record and TableUpdate() or TableRevert() when you are done.
Like I said, if you need an updatable view, then you need to include the PK. Make sure that in the Update Criteria tab of the view designer you check the PK (the little key) and all fields that are updatable (the pencil). Don't forget to check the "Send SQL updates" also.
For fields that are not in the view, you can define a default value in the table designer.
HTH
>If I have a form from which I want to enter a new record in the parent and child tables, should the objects on the form have sources that are memory variables from like, scatter memvar blank, or should they be fields from the views, like append blank and then use the view.field? If I try to use view.fields, it seems there is a problem updating all the tables and it has to do with the primary field (I think).
Previous
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