One Table or Two ?

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 Wed Nov 27 2002 - 13:44:42 CET