>Confused again!!!
>
>I have a table GROUP, w/primary key GROUPID. The primary key is assigned as the default value of GROUPID, w/a call to a GetKey( "GROUP" ) routine. Another table, PACSEA, has one or more entries w/a foreign key of GROUPID.
>
>I need to have the value for GROUPID before I write any records in PACSEA. This must be a common thing that people do, yet I'm having trouble figuring out the sequence.
>
>I am trying to use views to update both tables and am having trouble when creating a new group. Where should the GetKey call be? in the view or in the underlying table, or both?
>

I put mine in the table, and when appending a new record into a view, call the NewID function manually, and place the results in the view record. The primary key field in the view must be set to updatable for this to work.