Data Shaping

It has been a couple months that I worked on this project and kind of forgot how exactly this was done.

I have 3 tables in my db

The schedule table stores the location and course values are numeric values

The location table contains the locationID, location name, location address

I would like to substitute the locationID with the location name

This is all in a repeat area

Thanks...