Re: One Table or Two ?

Thanks Eric. I'm not too sure I understand.

If i do:
> Id, acrnonym, explanation, language

and someone only want to see reults in English then they won't be able to right ?

Also - the acronym will change based on the language.

Maybe I'm not quite understanding your theory.

thanks, dave

"Eric Manseau" <emanseau_at_cae.com> wrote in message news:<as2sbg$nj4$1_at_dns3.cae.ca>...
> Hi
>
> For me I will do the following:
>
> Table
>
> Id, acrnonym, explanation, language
>
> also with that approach you don't limit your self with 2 language.
>
> Regards
>
> Eric
>
> "Hunter" <dave_h4_at_yahoo.com> wrote in message
> news:27ad91d2.0211270444.25678abf_at_posting.google.com...
> > Hi All -
> >
> > I'm creating an online searchable acronyms dictionary. It wil be
> > populated with:
> > Acronym | What it stands for | Explanation of Acronym
> >
> > The user will choose in which language to recieve results (English or
> > French). I'm wondering if I should build it using one unique table, or
> > two tables:
> >
> > id acronym_eng acronyms_fre explanation_eng explanation_fre
> >
> > OR
> >
> > Table 1 = Acronyms_english
> > id acronyms_eng explanation_eng french_id
> >
> > Table 2 = Acronyms_french
> > id acronyms_fre explanation_fre english_id
> >
> >
> > TIA, dave
Received on Thu Nov 28 2002 - 19:11:41 CET