Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2005-05-04 : 14:15:08
|
I hate applications like this but I have to make someone happy...So here goes...I got several word documents that are fairly large and have TONS of check boxes that need to be used. I've been asked to make this web based since we want to actually report on the data, save disk space, and have historical data as well as some other things.Fine and dandy, I've normalized what seems to be hell right now and am now thinking about an interface. The problem is ... well the check boxes are kind of inconsistant. In some "sections" we have a single bit (one check box either on or off) which I can handle easily if this was the only thing across the entire section.But in the same section I may have a line item that is "Yes" or "No" (which is still one check box) BUT including that we have a check box for "N/A". I cant use a check box control since that only gives me one check box (which I originally thought was ok till I saw some areas with N/A). Then I thought about a repeater?The thing is some sections have an "N/A" others dont...so I was wondering if I can hide a check box inside a repeater given a condition. A sample screen shot of just ONE page of this word document is given below:http://www.jakrauseinc.com/jhermiz/yikes.jpgI am not too concerned with the table design, I had to get really normalized on this one only cause the users insist that there will be changes to the check boxes, the inputs, and the parents.Basically the word document as you can see is structured like so:Type Parent Inputs Processes Outputs References...Type Parent Inputs Processes Outputs References... Type is the type of "word document" that gets set for the project:Zone, Transport, Station, SE.Parent is the red item in the document imageAnd below those are the many side (check boxes)Currently the design is like so:Tables:Type----TypeIDTypeParent------ParentIDParentTaskManagerPredecessorSuccessorParentType-----------ParentIDTypeIDProjectType------------ProjectIDTypeIDInput--------InputIDInputParentInput-----------ParentIDInputIDProcess-------ProcessIDProcessParentProcess-------------ParentIDProcessIDOutput------OutputIDOutputParentOutput------------ParentIDOutputIDReference----------ReferenceIDReferenceParentReference----------------ParentIDReferenceIDProjectParentInput------------------ProjectIDParentIDInputIDValueProjectParentProcess--------------------ProjectIDParentIDProcessIDValueProjectParentOutput-------------------ProjectIDParentIDOutputIDValue I am still questioning whether I should use "Value" even here ... since I do have some "N/A"'s..but then again I can treat value as tiny or int.But what do the experts think gui wise to handle this? I know it seems over normalized but I almost have to. I wish it always stayed the same but this isnt the case.Thanks,Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
jhermiz
3564 Posts |
Posted - 2005-05-13 : 11:29:48
|
Resolved:Thought about this a bit more and instead of all these checkboxes I ended up using a datagrid with a combo box in it.Tables changed slightly as well.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
repeater ?