I am creating a custom report where that shows values from a specific table.
One of the fields in the table is a lookup field, containing two columns (ID and CompanyName from a query). I want to display the name in the report but it shows the ID instead. The data is retreived by an sql-query...