That being said, multisites have different databases and nothing data-wise is tied to the main site.
And I have no idea what you are speaking of when you talk about consolidating mentors. Do you have a business requirements document or process flow that can be shared?
You cannot search across multisite databases without a significant amount of custom work. It can be done, but it requires a lot of database design and you're going to have significant issues to overcome when consolidating data.
Each site in a multisite installation is an independent database. Multisite shares plugins and themes, but the data is purely independent. This means that when you have forms collecting data on each site, entry ids could easily be duplicated across the sites and there's no way to reconcile which entry id is the single source of truth. Your design creates an irreconcilable conflict. To search Formidable data, all entry ids must be unique.
I could tell you how to customize MySQL to access the data across multiple databases, but your choice to use multisite renders your overall goal unfeasible. You will not be able to consolidate the data to search as you want.
You really need to rethink your system design and focus on a single site that uses a hierarchical workflow to accomplish the goals. Do you have a BRD?
Please login or Register to submit your answer