Display foreign key name vs ID
I need to display the a foreign key name, however when I alter the query my results disappear. It seems as though DataAssist only pulls from tables. Is there a solution so that I can display the category name and not the id on my results page?