PMFJI, but you do not have to update every field in a multiple-table view. Just make sure the fields from the lookup tables are not checked as updateable.
HTH
Barbara
>Thanks for the reply.
>
>Why am I including more than one table in an updatable view. Welllll, that's an interesting answer to your simple question. Actually, I am only trying to update fields from the master table, and bringing a user friendly description of the foreign keys from the joined tables into the view.
>
>I am using MaxFrame Pro. and am immulating an example of the framework sample app. The user friendly descriptions are presented to the user in an F2 lookup field, and when the user selects from the lookup table, the foreign key field of the master table of the view is updated with the primary key from the lookup table, and the view is requeried.
>
>I have heard the rule of thumb concerning one table per updateable view. I just haven't figured out how to apply that rule here, in this context.
>
>I will get back to work on this, and let you know how it turns out. Your last suggestion about the FUNCTION...ENDFUNC is right on target. Thanks.
>
>Kendall