Database design. Dynamic fields?

HCL Domino Domino Forum
1

I am designing database and I am not sure how to organaze one of the forms.

On ProposalForm (response) they want to enter up to 50 lines of similar info: Product, Description, Quantity and Price.

This “table” should sit in the middle of the form. If user enters 7 lines, he does not want to see 43 blank lines.

I can see solution to this by creating 50 sets of fields, put tnem into 50 row table and hide those rows that have no data.

Is this the right way to do it?

Is there alternative?

Please, help

Thanks

2

Subject: Database design. Dynamic fields?

You may think about separate documents for the detail lines and imbed a single category view of them in the form. A table of the scale that you are talking about can be a coding mess when it comes to input validation, line extension and summarization. Then, about the time you think you’ve got it, someone wants to pull and summarize matching detail information across multiple forms… now you have to find and extract it all.

3

Subject: Database design. Dynamic fields?

Hi Igor,

I have used the Midas Richtext dll to do something very similar. It allows you to copy a row from a table, complete with fields, to a new row. Any formulae associated with those fields can then be automatically adjusted to the new field names (although this is less relevant with R6’s @ThisField)

Have a look:

hth

Tony