Dorin
I went back and read your response then decided to run gendbc after reading what Giesberg said, to see what was actually being built.

I missed the update check for the primary field. I does not get checked when you select all, it appears. Also the primary key for the 2nd table was checked, which was creating a conflict even though the update was not checked. Thanks a lot for your suggestion.

>Have you checked all view fields for update (including key field)?
>You can also set default value for view field nproperty to nextnum('propnum') and don't include it in your INSERT statement.
>Dorin.