Hello,

Each one of my links has a LocationID. There are 300 different locations which hardly ever change.

Each LocationID has a matching name.

To get the name of the location, I could either:

1. Add another field to the Links table called LocationName
2. Write a global, which contains a list of all the location names and returns the name given the LocationID
3. Add a new table called glinks_location which contains the columns LocationID and LocationName, and write a global which returns the name from the table given the ID

Considering there are 300 locations which do not change - which should I choose? Or is there another way?

Thanks in advance for your help!

Rob