How to run a report that pulls data from multiple tables

[Brendan_McHugh]

I have a database for a portfolio of commercial real estate property that I manage. There are multiple tables for the varying information we wanted to capture about the buildings. Now we want to run a report that pulls all of the data for any one of the given properties. Can anyone give me advice on how to do this?

Thanks.

[kuovonne]

Welcome to the Airtable community!

You need to use lookup and rollup fields to pass all of the data into a single table. Then you can run reports from the single table.