Portal of 1 field but 2 columns. 1 col for "Spanish" and one "French"
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:
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-