[Wolves] SQL problem

[Simon Burke]

On 17/3/04 10:53 am, "Simon Burke" <its_simon_burke at hotmail.com> wrote:

> On 17/3/04 10:35 am, "Chris Procter" <Chris at foxonline.co.uk> wrote:
> 
>> I'm a bit confused, are you trying to hold two copies of the same info, one
>> in english and one in welsh? If so could you use two fields in the table e.g
>> english_text and welsh_text and then pick which column you want on the fly
>> (dependant on some variable set by the front end)
>> i.e. "SELECT " & language & "_text FROM table"
>> with language = "welsh"
>> 
>> Or have I missed the point?
>> 
>> chris
>> 
> True true, the only problem we have is that data needs to e interchangeake
> between the both, so we need the ability to translate between the two,
> 
> 
Sorry I mean we need the dat accessable by both welsh and english users and
have it in their language