Display related data

I have a table “tad” that aggregates data from multiple tables. In tad I have a field that is “program_id”. On the tad index and view I wish to display the program name instead of ID. The keys are already set in the tables but I don’t know how get the programs.name value on the tad/index or tad/view