Language Translation Selection

[mveijndh]

Hi,

On an invoice I have a selection field Language referencing a table with Languages. I store the LanguadgeId in the field. While making the Query to print the Invoice I need to select the Select the The Invoice description from a table that has the translations in the fields. How do I select the correct translation in the Invoice??
How do I build the query that selects the correct translation!!

 

[sneuberg]

I think we need more information. What are the fields in the invoice table, the language table and how are they related.

 

[mveijndh]

I'll prepare a small database as example