In a datagrid, I get data from a detail table that has a FK with his master table, but one column in master table is FK with another catalog, I want to show description from this catalog not only its ID. What is the best way to do that?
I'm appreciate your help.