Jump to content
Salesforce and other SMB Solutions are coming soon. ×

retrieving value from related record


Recommended Posts

Hi all,


I'm currently in the process of restructuring my database a bit and would like to have some input on a question. The database centers around a set of sentences, of which I also have a set of translations. The original sentences are stored in one table , called Sentences, and the translations from the different languages are stored in another table, called Translations. A primary key in Sentences relates to a foreign key in all the Translations records.


Each record can be uniquely identified using real-world identifiers, namely an ID for the sentence and the name of the language. So, what I want to do is as follows:


Say I have these two translations with the same real-life ID, the 'type' field displays a classification of the linguistic structure:


English: John hits Mary

type = 3

Dutch: Jan slaat Marie

type = 1


What if I wanted to display the value for English in the Dutch record, say in a field called 'English_type'? Could I do that and how would I be able to do that?


Thanks so much, and sorry if I'm vague!

Link to comment
Share on other sites


  • Create New...

Important Information

Terms of Use