Hello. I'd like to ask the user community for some ideas/assistance on a design that I'm working on for an Enterprise client (200 + users) whose functional design specification using Zoho Creator (and yes - they want to use Zoho Creator) is to:

1. Track & Report on National Data - a compilation of each State's Data.

2. Track & Report on State Data - a compilation of each City, County, and Region that utilizes the software for their own respective Entity.

The National data will need to be kept in its own Zoho Creator program separately. Each State will run its own Zoho Creator application but needs to have its records (not all the data but certain data that is of national interest) put into the National Data tracking program.

Here's the intended database layout:

NATIONAL DATA > STATE DATA > LOCAL DATA

National data will have State Data which in turn has local municipal data.

Each State will run it's own Zoho Application separately and have its data also inserted into the National Data program.

My Design Idea:

1. a. Create a Zoho App for Each State and as part of the key information points that need to be part of the National Data are created, updated, or removed use built-in Zoho scripting to add, edit, and remove data into the National Database as it's entered/updated on the State Program's Database. 

1. b. Each City, County, and Local area's data will be within the State Program.

2. Whenever necessary, utilize Zoho Reports to "mine" the data collected on the National Database program for each state for comparison data.

If you have a better design idea or approach, I'd like to hear/read it.

Thanks.