Can you re
"Earl" <brikshoe_at_comcast.net> wrote in message
news:uafWmZQsCHA.2648_at_TK2MSFTNGP09...
> I suspect that "Benefit1", "Benefit2", etc. have actual names. I recommend
> you use something approaching the actual title of the benefit for your
> column title, i.e., OpticalBenefit, DentalBenefit, etc.
>
> I also STRONGLY recommend you read a book on database design before
starting
> this project. It will save you hundreds of hours (not to mention the
> education received).
>
> "Mohan" <mohantrkm_at_yahoo.com> wrote in message
> news:95ff6b66.0212301428.f911cfc_at_posting.google.com...
> > Hi All,
> >
> > I am a VB developer developing a new client server application using
> > VB and Oracle 8i.
> >
> > Please help me in designing database table for the following screen
> > where the user will select the required benefits. The benefits are
> > grouped and listed under different categories
> >
> > For example Under Category 1 there will be Benefit1, Benefit 2,
> > Benefit3,...., Benefit 8 and Other Benefit.
> > For each benefit a checkbox will be provided and user can select as
> > many as benefits. If the user selects "Other Benefit" checkbox
> > user have to enter a new benefit inside a textbox.
> >
> > Like this there will be some more 7 or 8 categories.
> >
> > The table will get atleast 1000 rows a day
> >
> > In this scenario
> > 1. I proposed a design with one column in table for each checkbox in
> > the screen. If a checkbox is selected "1" will be stored in the
> > corresponding column else "0" will be stored. For the checkboxes with
> > caption "Other" the text entered in the text box will be stored
> >
> > 2. My colleague suggests to use nested table for each category
> >
> > 3. Is there anyother good solution?
> >
> > 4. What are the pros and cons in using nested table for VB app?
> >
> > Can anyone please suggest me a solution which will be good for
> > programming and reporting
> >
> > Thanks in advance
> > Mohan
>
>
Received on Sun Jan 05 2003 - 21:06:12 CST
