Table Design Qn

[WebNickson]

Hi,

I have a Form that comprises of abt 50 entries in the same page. Most of the entries can only have 1 value except for 3 entries which can have multiple values. There is no constraints imposed on each other for these 3 entries.

Under such circumstances, how should the database tables to store the form entries be designed?

Should I have just
1) a single table to store all data. For those with fields with multiple values, I would concatenate the values together with comma separator.

2) a single hdr and dtl table. Dtl table is to store the multi valued entries.

3) a hdr and 3 dtl table; each dtl table for the entries with multiple entries.

Of course, the form entries will be subsequently used in reporting.

Would appreciate very much the advise from you guys on which is best approach.

rgds,
Nickson


rgds,
Nickson

 

[avjoshi]

If the number of values for those three fields is always the same then no. 2) would be good oftion.

If they have varying number of values then no. 3) would be the option.

Hope this helps.

Anand