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?

If it's in both, it seems that a new key is generated when inserting into the view and when inserting into the table.

ANy input is appreciated. J