I'm new to SharePoint and I'm having trouble understanding how to do something that seems simple.
I have a list
People and a list
People has columns
Rooms has columns
Space Type, and
Occupant is a lookup for
I would like SharePoint to auto-populate the
Room column in
Occupant is updated in
Rooms. For example, if I enter Doe in Occupant for room number 1,
People should show that Doe is in Room 1.
I tried making
People a lookup, but that had no effect. I also tried following this question, but nothing happened (not sure if I did it correctly) and read other questions, including this one and others mentioning workflows and events, but I don't know how that would work or how they are implemented. I think I'm using SharePoint 2010 online, but apparently there's no way to find the version?
Is there a way to update one list based on another?