Portal of "Glossary" field with two columns, one "Spanish" a

[LanguageAmbassador]

I want to use a portal to display I guess what you'd call two "instances" of one field. Table "Glossary" has only two fields: "GlosId" and "Word." See following:
 
Table: Glossary
Field: GlosId (number, where records 0-199 are for Spanish words, and records 200-299 are for French words)
Field: Word (text, Spanish or French words, depending on the value of field "GlosId")
 
In the data entry/viewing GUI of the database (layout for table "References"), I've labeled the left "instance" as "Spanish" and the right "instance" as "French," but it does not work right. I want the Spanish "instance" to display only records whose "GlosId" values are 0 to 199, and I want the French "instance" to display only records whose "GlosId" values are 200 to 299.
 
Below the portal I want to display two simple text fields, "Def" and "Ex," which simply provide the definitions and examples respectively of the Spanish or French word that the user selects in the portal. 
 
CAN THIS BE DONE? PLEASE OFFER SOLUTION OR A BETTER WAY! THANKS-

 

[gmannatl]

You are approaching this from the wrong way. I have downloaded the file and can fix this for you, but I have a question.

On the references layout how exactly do you want this to work. Are they going to use a drop down to select an english word or just create a new record with the GlosID? I am just trying to understand exactly how it will function. Either way, there will need to be structural changes to the way the dbase.

 

[LanguageAmbassador]

Thank you for stepping up, gmannatl. Apologies for just now getting back to you. I just started a new contract and have had much less time than I'd like for devoting to the development of this concept. I really hope you can help me out. I'm onto something that no one else is doing, and I've got high hopes for your help. Please hang with me, because this thing is going places.

OK, you basically asked the following:"Are they [users] going to use a drop down to select an english word or just create a new record with the GlosID?"

No drop down anywhere. I guess the sensible thing to do would be to have a [*New] button on the GUI. I'm trying to keep the GUI very simple at this early stage. Once I get it to work with a few controls, then more can follow by modeling the same schema and functionality.

As for functionality, it's absurdly simple. The GUI has three controls (four counting the [*New] button):

The user scrolls or tabs through the (1) portal from field to field or record to record. When the user selects a given cell in the portal, the value of (2) the [Definition] text box is an a definition expressed in English. (3) The [Examples] text box's value is a list of examples expressed in English.

Each cell in the portal has unique values in the definition and the examples text boxes. Within the portal itself, the user sees how to say the same word in either Spanish or French. For example, one record in the portal might be "Palabra (la) - Mot (la)." When the user gives focus (selects) "Palabra (la)," the value of the definition field is something like "(1) Word, (2) Secondary definition." The value of the example field is something like "Busco una palabra (I'm looking for a word)." When the user gives focus to "Mot (la)" the value of the definition field is "(1) Word," and perhaps no secondary definition is given. The value of the example field is something like "...sentence in french using 'mot' (...translation in English)."

Again, really looking forward to your help with this!

 

[JeanW]

Like your modeling is now, it will never work.

Basically you're talking about a many to many relationship.

To solve this you need to transform this to two one to many relationship.