I need your help in a process that I need to do.
Let me explain.
When I get a word from my text, I insert it into a Table, this table has 3 fields:
EnglishWord
PortugueseWord
IndexWord
IdText
My text is in english and when I get some words from it, I insert into this table so that I can inform in the field PortugueseWord its translation. Well, It is ok so far, I already do this.
My problem is being here:
As you can see, There is another field named IndexWord, this field is the ID sequence of list words in table, I need a way to have a reference the word that was copied from text in it.
For example this Text:
If I took the word "acclaimed" , I'd like to insert by its side the reference id that the word is the x number in my list table, so that when I click on the word in my list it can be found.The Beatles were an English rock band formed in Liverpool in 1960, and one of the most commercially successful and critically acclaimed acts in the history of popular music. The group's best-known lineup consisted of John Lennon (rhythm guitar, vocals), Paul McCartney (bass guitar, vocals).
I could use the search word, but the problem is that the list can have more than one word, that is, a repeated word. Better, I can have "acclaimed" twice or four times in my list word, because a word can have several meaning and its meaning depends on the context.
This number by its side can't be visible, it must be hide.
My doubt are:
1) How can I insert a number by its side in a hide way?
2) How can I search this hide number?
I am not sure if this is the better way to do that. If you have any better ideia, you're welcome.
Thanks
Alex