I have two apps - one which tracks financial performance data from multiple sources and one that manages projects. We've just been informed that we have to track the tasks for one project in the project manager, and the dollars in the financial app.
I need to be able to track two separate lists of initiatives in the two apps, but make them "talk" to each other such that the intersecting initiatives have their dollars tracked in the financial app and their tasks tracked in the project manager in a simple, efficient manner.
The issue I'm running into is that I can't use Sync because there are a couple hundred initiatives in each database, and only about 30 have to be tracked in both. I need to be able to pull a subset of initiatives from one app into another but still free key the additional, non-intersection initiatives.