I would make Project Export (scratch) table to hold the normalized results. By a scratch table i man a temporary table which is just used to collect the export data.
Then I would make 8 saved table to table imports to export the data from Project Entry. Each would be filtered respectively when Project # X has data.
Then I would make a URL formula button would would do 10 successive steps.
Delete all records in the scratch table.
Run each of the 8 saved table to table imports.
Land the user on the scratch table.
If you need help with building that button, I can help you once you do the other setup. Once you do the setup though, you can run each import once, manually, and see the result.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
