I think this is easy, but I just can't figure it out:
Here's a simplified version of my tables:
TBLMain
ID
HousingStatus=Valuelist from TBLStatus
FoodStatus=valuelist from TBLStatus
TBLStatus
ID
Status
StatusValue
I'm running a query that displays all the fields in TBLMain. I show only 1 field in the value list for HousingStatus and FoodStatus, but I'd like my query to show Status and StatusValue.
This is really easy, right?