DB design opinions

[Ruslan Zasukhin]

on 1/13/04 7:41 PM, valentina at panamind.com at valentina at panamind.com wrote:

> I have an interface design where fields can have multiple values,
> usually displayed in a listbox. Currently I use separate tables for the
> fields linked to the main table. An alternate method would be to store
> the values as a delimited list in a VString field in the main table.
> 
> I don't have a problem with either method but would like opinions from
> others on how they handle similar situations. Is there a  disadvantage
> to having a high number of tables or does it matter?

Hi Gary,

If you going to have table for each category, then this is not very good
idea.

It is better then, to use single table, and have field CATEGORY.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------