I have a table that uses a lookup to get an item from a query. That query combines two fact tables (a category and its subcategory) in order to create a readable name for users doing the data entry/updating by joining them and concatenating the strings. The SQL checks out and the query runs...
