I figured out how to change the fields in a calendar to add extra info about events. Is there a way that I can take the fields that popup when I try to add a new event and get a dropdown table based on existing SP lists?
For example, location is a field that needs to be filled in when a calendar event is made, so how can I make the location field a dropdown populated by my Locations SP list.
Further than that is there any way to do this and combine a SQL Server Table and a SP List together? Like if I had my SP list but I also had a DB of locations that would be changed by those who have access to the DB but not the SP lists?