Yeah, that's what I concluded too. I was trying to use what was already there, since the Spanish is a new requirement. Previously I was just using the English Category itself rather than the key.
Thanks, Ben > -----Original Message----- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Monday, December 04, 2006 02:38 > To: [email protected] > Subject: Re: Witango-Talk: Brain lock > > Ok, I'm trying to understand here > > if you have a table with > > 1. Unique ID > 2. English > 3. Spanish > > Don't both translations have the same unique ID? > So if you put the ID in book table it just a matter of what > translation to display > > Ben > > > On Dec 4, 2006, at 10:16 AM, Tom Ferguson wrote: > > Sorry for the seemingly simple question, but my brain is > locked up today. > > I have a table with a category field, and a spanish > translation for this > category: EnglishCategory and SpanishCategory. The Category > Table contains both Translations > > These categories apply to books. > > In the book table I display the English Category and allow > them to update it. The dropdown displays the current value > in the book table in the dropdown and allows them to pick > other categories from the category table. > > In the book table, I also have Spanish Category. > > I'd like to display only the English Category and when it is > chosen, update the Spanish Category as well, without having > to display it as a separate field. It needs to be shown in > English on the update screen because the folks who are doing > the updating are not necessary fluent in Spanish. > > > > TIA > > Thomas Ferguson > Vice President > Enroll DR, LLC > 7115 3rd Street North > St. Petersburg, Florida 33702 > 727-577-7474 > > www.enrolldr.com > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
