Hi,
I have a Table Box that consist of name/value pairs (two columns) and I need to show the name column in the table in different languages depending on the users language. Normaly (in VB6, .NET, basically anything other than Navision) I have a ID column for the name and I exchange that with the values stored in a lookup table in my SQL statment that fetch the data and bind to the resulting RecordSet or DataSet to the grid.
Is there any way in Navision to show a column from another table in a Table Box than the one defined in SourceTable? Is there some other way to make the content of a column be translated to the language in use?
0
Comments
If I understand you correctly, you want to build a form that looks a bit like the Properties window in C/SIDE, but with language-dependent property names. I think I'd write a function in the SourceTable that retrieves the left-column value from a table with translated descriptions, and use that function as the SourceExpr for you left-hand column text box.
Jan Hoek
Product Developer
Mprise Products B.V.
RIS Plus, LLC
MVP - Business Apps
Imagine the Properties window in C/SIDE supporting property names in the current application language - that's the effect that munson is trying to achieve, if I'm not mistaken.
Jan Hoek
Product Developer
Mprise Products B.V.
Jan Hoek
Product Developer
Mprise Products B.V.
RIS Plus, LLC
MVP - Business Apps
So:
Column "Name": Height
Column "Value": 20
or
Column "Name": Hoogte
Column "Value": 20
or
Column "Name": Hoehe
Column "Value": 20
Jan Hoek
Product Developer
Mprise Products B.V.
I have implemented his first suggestion with using a function in the SourceExpr and it works just as I wanted. Another good thing about that solution is that it keeps the amount of data down since it does not store the same texts over and over. I will stick to this solution.
RIS Plus, LLC
MVP - Business Apps