We are trying to implement a small workshop registration system on our SharePoint.
Workshops are offered in different cities and at different times a year. For each event we have a list where people can sign up. However, I need the date and location information to be pre-populated as soon as a new item is created (or on the new item form, whichever is easier).
I thought about creating a separate "master" list with each workshop information, but I'm unsure on how to relate these two lists. I would still need an ID of some sort to relate to the correct workshop on each registration list
Any help will be greatly appreciated!