A Report of any kind can only show records from one table.
But one solution would be to make a new table which would give consolidated records form the two tables. If it wuz me I would make a URL Formula button which would purge the records in the consolidated table and then run two saved table to table imports to re-populate the consolidated table and then display the calendar report. The button would run very quickly so the users would not really know that it was doing all that work.
We can get that working slowly on this forum or else quickly if you want to contact me for one on one assistance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------