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:
Thanks in advance for your help!
Rob
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:
- Add another field to the Links table called LocationName
- Write a global, which contains a list of all the location names and returns the name given the LocationID
- 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
Thanks in advance for your help!
Rob