Peter E.
|
| Posted: 09/27/2002, 3:35 PM |
|
I want to make some pages with Frequently Asked Questions (and answers),
wher the questions are organised in categories.
But some questions (with answers) belong must appear in several categories
at the same time. An this is something I can't figure out how to do in an
Acces database.
I came up with something like this:
tabel1: category_id,category_names (here you can enter categories and enter
new ones later on)
tabel2: faq_id, question, answer, (and then ? where and how to show that a
question belong in several categories?)
Anyone an idea?
peter
|
|
|
 |
Shawn Mason
|
| Posted: 09/27/2002, 4:41 PM |
|
Hi Peter,
Basically you need a third table; thereby producing a many-to-many
relationship. The third table would have 2 fields. Category_ID and Faq_ID.
This is the table you would actually create the grid for. This adds an
extra step but it does the task. I would ease the burden by automatically
assigning a category to the faq on insert (this would require doing another
insert in the After Insert event). Then if the faq needed to be in another
category, you could go and add it to the table as well. This would help
since there is a good chance that most questions may have only one category.
--
Kindest Regards,
Shawn Mason,CCD,MCP
I.S. Software Design Associates
"Peter E." <dutch-trail@REMOVETHISPARTenkhuizen.net> wrote in message
news:an2mfq$jrm$1@news.codecharge.com...
> I want to make some pages with Frequently Asked Questions (and answers),
> wher the questions are organised in categories.
>
> But some questions (with answers) belong must appear in several categories
> at the same time. An this is something I can't figure out how to do in an
> Acces database.
>
> I came up with something like this:
> tabel1: category_id,category_names (here you can enter categories and
enter
> new ones later on)
> tabel2: faq_id, question, answer, (and then ? where and how to show that a
> question belong in several categories?)
>
> Anyone an idea?
>
> peter
>
>
|
|
|
|
Peter E.
|
| Posted: 10/03/2002, 4:43 AM |
|
Thanks, I will try that!
Peter
°°°
"Shawn Mason" <shawn@issda.com> schreef in bericht
news:an2qbd$qh1$1@news.codecharge.com...
> Hi Peter,
>
> Basically you need a third table; thereby producing a many-to-many
> relationship. The third table would have 2 fields. Category_ID and
Faq_ID.
> This is the table you would actually create the grid for. This adds an
> extra step but it does the task. I would ease the burden by automatically
> assigning a category to the faq on insert (this would require doing
another
> insert in the After Insert event). Then if the faq needed to be in
another
> category, you could go and add it to the table as well. This would help
> since there is a good chance that most questions may have only one
category.
>
> --
> Kindest Regards,
>
> Shawn Mason,CCD,MCP
> I.S. Software Design Associates
>
> "Peter E." <dutch-trail@REMOVETHISPARTenkhuizen.net> wrote in message
>news:an2mfq$jrm$1@news.codecharge.com...
> > I want to make some pages with Frequently Asked Questions (and answers),
> > wher the questions are organised in categories.
> >
> > But some questions (with answers) belong must appear in several
categories
> > at the same time. An this is something I can't figure out how to do in
an
> > Acces database.
> >
> > I came up with something like this:
> > tabel1: category_id,category_names (here you can enter categories and
> enter
> > new ones later on)
> > tabel2: faq_id, question, answer, (and then ? where and how to show that
a
> > question belong in several categories?)
> >
> > Anyone an idea?
> >
> > peter
> >
> >
>
>
|
|
|
|
|
