Too many fields in a form?

Hi Everyone!

I have a BIG problem .

I´m designing a form containing a table with 1 column and 60 rows.

In each row there is 1 textfield where I can insert a headline.

1 field (combobox editable) containing 27 choises.

And 27 sections containing 269 fields.

When I make a choise and update the document(form) on the webb it

displays the selected section.

I must be able to do this in every row.

It worked on the first 8 rows , but when I´m designing the 9th row

on the form and try to save it, I get the error message "field is

too large (32k) or view´scolumn and selection formulas are too large".

I suspect it means that I have too many fields.

But if I can´t do it like this what should I do?

The user must be able to chose any of the 27 sections in every row

on the web.Please help me .

Thank´s in advance.

Robert

Subject: Too many fields in a form?

Are you saying there are 27 sections in each row? 269 fields combined in the 27 sections, plus the combobox? 270 fields * 60 rows = at least 16200 fields on the document?!?!?!?! Say it ain’t so! I had to try and “fix” a form that had 1000 fields and I thought that was a gross amount for one form.

I would suggest going back to the drawing board on the design and figuring how you can split it up so it is more than one form. It’s hard to suggest a the best way to do this without knowing the full situation.

Subject: RE: Too many fields in a form?

It sounds like what you need are 27 forms. Each “section” becomes a document. And when you want to display the whole thing, use RenderToRTItem to insert images of each document into one cell of the a table in a rich text field.

Honestly, what are people supposed to do when they want to clear the information in row 2 of 45? Manually shift the information up from each subsequenbt cell to fill the gap?