I want my users to be able to select from a predetermined list of UK towns and cities when they post an event, such as ‘my event is in Bath, UK’. Then, people can search for events in their area, in this case ‘Bath’.
The list will look similar to this;
So, I have two Datatypes (Users, Events) and both need to make use of the location drop down list. Should I have a separate Datatype and have both refer to this, or should I have the full list of 100’s of towns and cities in both datatypes? Also, is there an easier way to add the list of towns and cities to the database rather than one by one manually?