I have two related SharePoint lists; List A uses a SharePoint assigned ID number that becomes the Case ID number for the related List B. I would like to create a third list, List C, that is automatically updated with new or changed information from some of the fields of Lists A and B.
For instance, List A contains the ID, Name, Badge number, date of start and date of processing. List B contains the ID using a LookUp, date of meeting, date of letter, date of reply. List C would contain date of start, date of processing, date of meeting, date of letter and date of reply, combined from both lists into one item. The Workflow would then add new items or modify previous items based on work done in List A or List B.
Thank you in advance for your assistance.