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
