Our non-profit organization helps sponsor children in Africa. We have multiple applications set up to do separate functions. One application contains tables related to the child, school info and sponsors name. Another application contains tables related to the sponsors and their pledges, financial info. etc.
Questions:
- Is it possible in Zoho to create a report (view) in the child application that can display all the child/school related data plus access the sponsor table in the sponsor application to pull out the sponsor's data like address, city, state, etc. and have the data from both applications display on this one report (view)?
- If yes, what if the user has access to one application and not the other application? Would this combined view still work? For example if the user has access to the sponsor application but not the child application would the report that takes data from the multiple applications fail to run?
Thanks for your help.
Jim K.