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.
Extreme Programming = Plan -> Design -> Code -> Test