A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help w/ table design



 
 
Thread Tools Display Modes
  #1  
Old August 12th, 2004, 02:34 PM
Tom
external usenet poster
 
Posts: n/a
Default Need help w/ table design

I have a question about table design (in conjunction w/ form design).

Although this question is focusing primarily on table design, I'd like to
start out w/
providing information about the form first.

I'm working on a prototype for a Scorecard (form).

On the final form, I envision to have the following:
- No textual data and no numeric information
- Instead I want dozens of "colored boxes" (text boxes).
- These boxes are linked to fields that store numbers such as "25, 50, 75,
100".
- The numbers correspond to %-levels of a) achieved tasks or b) unfinished
tasks or
c) tasks behind schedule... or whatever I'm tracking
- A "green box" (100%) reflects completion... a "red box" will raise concern
(at least it should)...
- I then could click on the "red box" (OnClick event) and will bring up the
underlying data (e.g. 25%) plus more descriptive information such as task
issue, delays, etc....
- Again, I might want dozens or even hundreds of these boxes (very small in
size) on a single form. The large number of small boxes would be grouped
into a) processes, b) years, c) quarters, etc.

Okay, I hope I was able to provide a good "mental picture" of the form
product (just in case though, I have attached a small JPG that illustrates
the prototype).




Now onto the actual question... "How to construct a proper table?"

With the current db draft, I ended up creating the following:
- 1 table which has...
- 1 record which has ...
- right now, 24 fields... each task has a field name... and, as stated
before, I might end up with hundreds of tasks... resulting in hundreds of
fields

Managing such table (w/ hundreds of fields in e.g. a single) seems simply
ridiculous and impossible... and goes against any logical database design,
right?

So, my question is:
How should I set up the table so that I have only a few fields (e.g. "Task",
"Year", "Quarter") and hundreds of records...

in conjunction with the form...

If I had a record for each task (which is logical db design),
I couldn't show all records (and their overall summary e.g. "25, 50, 75,
100")
on a single form, right?

Wow, I hope this is not too confusing... if you feel comfortable opening up
the JPG,
I believe this thread would make much more sense.


I appreciate any help that would enable me to make some progress on this.

Thanks,
Tom








Attached Images
File Type: jpg BSC.jpg (27.2 KB, 22 views)
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Modifying table design breaks Append query MKH Database Design 2 June 15th, 2004 04:05 PM
resize table from A4 size to A5 ims New Users 3 June 9th, 2004 01:05 AM
Table design question - advice needed David Database Design 3 June 8th, 2004 02:21 AM
COMPARE THE TWO TABLES Stefanie General Discussion 0 June 4th, 2004 04:36 PM
Will my table design cause future problems Aaron Database Design 9 May 4th, 2004 05:34 AM


All times are GMT +1. The time now is 08:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.