IS it possible to link or sync 2 SharePoint lists together - more specifically I'm using the SharePoint lists for fillable forms, so if a user clicks "new Item" it pops open a form I made in InfoPath (where the columns are the question fields) for users to fill out.
My ask is this: If I have the main form (lets say 50 questions) that users will fill out - then I have a small list (5 questions - but it's 5 questions that are included in those 50) it's for a different team that just cares about those 5 questions - is it possible for one to send data to the other or sync?
Currently, once the big form of 50 questions is filled out, I will go in, look at the 5 questions, and then fill it out manually on the other form just for those 5 questions - obviously this is very tedious and can take a while - so I'm wondering if upon the main form being filled out if there is an action that can automatically create a new entry for the small list, and have it with those 5 questions.
Furthermore, to make things difficult, I have 2 fields/questions in that list that aren't from the original. So it's a list of 50 questions, and then a small list that has 5 questions from the 50 + 2 more that are brand new questions. Will that not work? Is it only going to work if it's the exact 5 questions to mirror?
Thanks for the help in advance - and I will be able to clarify further if needed.