I am trying to correlate several tables in Access so if one piece of data is updated, then it updates it for all correlating data in the table(s0. for instance, we have applications and staff who are on call for each application. If i was responsible for several applications, but i couldn't be on call due to personal reasons, then someone could update my name in one table and it would update in all areas.
I am thinking this can be done with the relationship function and since i have never utilized this function before outside of just doing table joins for basic queries, i wasn't sure if this functionality would provide the desired output.
Currently these table are linked to a sharepoint site and based on my research it doesn't appear this functionality could occur with linked tables. Am i correct on that piece?
Any insight and guidance would be appreciated. Let me know if need any additional clarification.