Store a variable in a text field from another column

[cruisy]

Hi there,
Is it possible to store a field from one attribute in a table and refer to it in the same table within a different attribute?

I may be getting myself confused or there may be a more logical way to approaching this but I will explain what I am trying to do:

For arguments sake I am making a simple dictionary. A text column called "word" contains the words (ie "apple", "banana", "carrot" etc). Within the same table I have another text column called the "sentence". This contains the "word" word in a sentece ie "I took a bite from the APPLE", or "The man slipped on the BANANA peel".

It would be nice in the "sentence" field if I could refer to the word in question as a variable ie "I took a bite from the %column(2)%" etc to avoid spelling mistakes word adjustments etc...

Any thoughts anyone or am I asking too much?

 

[neileg]

I'm not sure about the logic of what you want, but why not do it in a query? Eg, suppose you have a field called Word called, one called Sentencestart and another called Sentenceend. Then create a calculated field called Sentence like this

Sentence:[Sentencepart] & [Word] & [Sentenceend]