Have I a fatal table design or am I asking for the wrong type of R

Have I a fatal table design or am I asking for the wrong type of R

Post by RGVubml » Fri, 12 Sep 2008 05:57:02


irst off, I have NO IDEA what you're trying to say. Second, you must be an
old COBOL programmer (like me), because you like 120 character field names.
I'd get rid of the following part of the field names:

SPA_Dist_Number_Name_

That does nothing for you.

Further down in your post, you start using the term "queues". I'm not sure
in what context you mean that.

In any event, I'd have a Contacts table that lists than name, party,
district number, etc, but then add a code indicating what body they belong to
(i.e State legislature, federal legislature, house, senate, etc.)

I'd create a second table that had all those possibilities, each associated
with a code number, and that code number goes into each Contacts record. When
you link the tables, the code will allow you to pull up the body's
description from the other table.

The way your table is currently created is IMO some very bad design. It is
not normalized properly at all.

Another way would be to have a LegislativeBody table, and assign Contacts TO
that body via another table. Lots of ways to do it, but NOT the way you've
tried.






" XXXX@XXXXX.COM " wrote:

 
 
 

Have I a fatal table design or am I asking for the wrong type of R

Post by S0FSTCBERV » Fri, 12 Sep 2008 06:02:11

OW!
Drop those long field names.
Have names fields, Branch
(Represenative/StLegislature/Senate/StSenate/Council/etc), Party, District,
City

Use the report Sorting And Grouping feature.

--
KARL DEWEY
Build a little - Test a little


" XXXX@XXXXX.COM " wrote:


 
 
 

Have I a fatal table design or am I asking for the wrong type of R

Post by Realitygd » Fri, 12 Sep 2008 07:02:02

n Sep 10, 1:57爌m, Dennis < XXXX@XXXXX.COM > wrote:

Karl卙ow to do I say thank you for showing me that simplicity is
complicity in and of itself卼hank you for showing to me how best to
drop those long name to show that brevity is beautiful when timely
applied卼hank you for taking the time to sharing this insight with me? G. Kennedy