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).


>Hi Mary-Ann,
>
>If you want your views to be updatable, yes, you need to include the PK. Otherwise, you can omit them.
>
>HTH

---

>Do views have to have the primary key in them? If you have six tables in a database that are related, and you choose to work with views, can you just pull out the fields from each that you need.