I have an updatable view I have been working on that has grown to about 130 fields. I am getting an error now that says there are too many fields to update.

I know I should probably normalize this to limit the number of fields. I could seperate out several of the fields to another table but the way the data is being collected it would still be a 1 to 1 relation to the subtable.

I could really use some advice. Thanks in advance,

Randy