Forum Discussion
Entering a contact column within Sharepoint
Create a list called Guides for example. It could contain columns for Guide Name, Guide Email etc.
Then in your main list, let's call it Bookings, add a lookup column against the Guides list you just created, and pull in the Guide Name column, and also choose "Add a column to show each of these additional fields:" and select Guide Email. Then when you add a new booking, you'll be able to add the name of the guide right from the new item screen, and when you save, that guides email will also be added to the item in the Bookings list. Hope this helps
radioroundup Great, thanks for that, that makes sense. I assume I'd have to update this list if we add new guides to our contacts. This doesn't happen very often, so wouldn't be too much hassle to do.