>>Is it because this is a join and it is double pumping the same table in generating id's? accnt.accntid has a different name instead of uid for all the keys.
>
>
>Stephen... any chance you got NewID() as default value in both view and underlying table?
I don't think so. When I gen the code via EView I don't see any dbsetprops for a default value.
When you do it from the commmand window via use lv_cust_accnt alias...
appe blank, create data that will go to both tables, it works.
In the standard bizmaintenanceform when they hit the new button page 2 pops empty and they can add data. Page 3 holds the data from the other table. Tableupdate() at that time and I see that the view shows a value for custid, but the actual table as a different one.