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

If you don't mind a vertical view, append the six records with the
appropriate foreign keys and display them in a subform for editing. The "At
Your Survey" sample uses this functionality in appending survey question
records http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP

"Todd" <cashlord@xxxxxxxxxxx> wrote in message
news:u3J9oE3BHHA.3604@xxxxxxxxxxxxxxxxxxxxxxx
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

  • Array based Binary Heap in C
    ... If array has five elements then this should be the Binary-Heap, ... void PQ_heapify_up(long int); ... grade: G-First ...
    (comp.lang.c)
  • 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: An array within a table--Break into 1-to-1 mini tables or separate rows?
    ... multiple rows for keeping the grade values. ... User interface should not drive table structures. ... The reason I kept leaning towards putting the six grade fields into 1 ... Grade_CommunicationRating Int ...
    (microsoft.public.access.tablesdbdesign)
  • 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)
Loading