Re: one record or many?

"Jeffrey Baler" <jbaler_at_hcri.harvard.edu> wrote in message news:<M3CZ8.20003$2v1.12210_at_nwrddc01.gnilink.net>...
> Hello all,
>
> If a paper form is used to capture data in a "table format", with a fixed
> number of rows, how should this translate to a relational table?...should it
> be multiple records with the column attributes named as the paper form has
> named its column headings? Or should it be translated into one record with
> each attribute capturing one field of data from the paper form?
>
> thanks in advance,
> JB

   Without knowing the contents of your form, we can only advise thats it's generally a bad idea to ever design your tables based purely on form or screen content. You may well have multiple entities represented that should be broken into 2, 3 or more tabes.

-bjh Received on Mon Jul 22 2002 - 10:09:31 CDT