I'm using FB 1.5.1 with XP Home SP2 and IBExpert.

I have two tables linked in a 1:1 relationship; the detail table
uses it's Primary Key as a Foreign Key to the master table. (BTW -
should I even have a Primary Key on the detail since it appears that
FB generates two Indexes for the same field when the detail table is
created?)

I have constructed a view with both these tables - using Helen's
excellent FB book I've been able to write an insert trigger to
insert a new row into both the base tables.

My problem arises when I want to update the base tables through the
view. My before update trigger allows (for example) a field value
to be entered into the IBExpert data grid and accepts the value when
I press the post key - however, when I perform a commit the field
reverts back to it's original/old value - with no error message or
any other indication of a problem.

I know that this is my fault/misunderstanding - since the examples
given in Helen's book work properly.

Any information or suggestions would be greatly appreciated.

Thanks

Peter