I have 2 lists on Site A that includes all parent Business Areas and child Job Titles my department supports and this site acts as a data warehouse for a number of other apps/dashboards to push/pull data from. I do not have a direct relationship built via lookups between these 2 lists, but rather use the parent ID as a reference to connect to the child list. So far this has worked fine for what I've needed to do.
I have another list on Site B that will become a training event calendar - it needs to use the same Business Areas and Job Titles as choices for audiences impacted by a training event. My goal is for Site A's lists to be the primary/authoritative source so if we make updates to areas/titles there, it will cascade to Site B's list too.
In my app, I have connected both lists and created some forms with dropdowns pulling in the choices from Site A's lists, but I'm struggling with how to pass the choices selected to Site B's list. Ideally, it would pass to a choice column on Site B, but can try to manage with it passing as text instead. It does need to be multi select if that matters.
My goal is for an event/line item in the list on Site B to choose multiple Business Areas from a dropdown, then a checklist to appear with the related Job Titles where users can select the appropriate titles and save them to that record. We will need to be able to do filtering and sorting of those audiences so we can drill down to see which areas/titles are impacted.
What's the best way to do this with the lists being on separate sites that are not directly connected (and I don't have enterprise site administrator access)
