Re: An array within a table--Break into 1-to-1 mini tables or separate rows?

Whoa. I think you caught me. This is why I keep on choking on creating
multiple rows for keeping the grade values. I think I just keep wondering:
how am I gonna populate the form without doing a ton of vba coding .

Putting all the rows into a single table lets me do a quick form but kills
normalization.

Any hints on how to easily display all six Yes/No records on 1 form as
checkboxes?

Thanks


"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
news:%23QYpy62BHHA.2328@xxxxxxxxxxxxxxxxxxxxxxx
As John stated "Fields are expensive. Records are cheap."

User interface should not drive table structures. If you have questions
about creating a user interface for easy data entry, ask away.

--
Duane Hookom
MS Access MVP


"Todd" <cashlord@xxxxxxxxxxx> wrote in message
news:Og8pQ81BHHA.3536@xxxxxxxxxxxxxxxxxxxxxxx
Guys, thanks for your quick answers!

The reason I kept leaning towards putting the six grade fields into 1
table instead of making them into 6 records is that, when a user enters
the grades, all six records must be created anyway.

6 child records created for every parent record. Is this a bad thing?
(This kind of made me want to just lump them all into the parent table.)

Thanks alot!


---------------
The un-normalized table:
ID PK
Name Varchar
Age Int
Grade_CommunicationRating Int
Grade_Cleanliness Int
Grade_TaxCompliance Int
Grade_Staffing Int
Grade_Insurance Int
Grade_Stocking Int
Grade_OVERALL Int


Normalized:

MAIN TABLE:
ID PK
Name Varchar
Age Int

GRADES TABLE: (Six records created everytime a new MAIN TABLE rec
created)
ID PK/FK
GradeType PK
Rating Int






.

Relevant Pages

  • Programming project help
    ... number of satisfactory scores the number of unsatisfactory ... scores and the number of invalid scores (less than 0 or greater ... int main ... outstanding = grade; ...
    (comp.lang.c)
  • programming project, revise
    ... number of satisfactory scores the number of unsatisfactory ... int main ... int outstanding, satisfactory, unsatisfactory, invalid; ... outstanding = grade; ...
    (comp.lang.c)
  • Re: Programming project help
    ... should count and print the number of outstanding scores the ... scores and the number of invalid scores (less than 0 or greater ... int main ... outstanding = grade; ...
    (comp.lang.c)
  • Using arrays in C.
    ... the grade. ... int enterInfo ... cin>> Stud_Num; ... cin>> response1; ...
    (comp.lang.c)
  • Re: An array within a table--Break into 1-to-1 mini tables or separate rows?
    ... User interface should not drive table structures. ... Name Varchar ... Grade_CommunicationRating Int ... GRADES TABLE: (Six records created everytime a new MAIN TABLE rec ...
    (microsoft.public.access.tablesdbdesign)