A nifty feature in Zoho Reports is the way it supports
relational data modeling. You can create or import a reporting database consisting
of multiple tables which have relationships defined between them as in a relational database.

In relational databases world, tables are related using Foreign Key relationships. In Zoho Reports, this is done using the Lookup Column feature where a column in one table points to a column in another table.

Relating tables with Lookup columns

Let
me explain this by creating a sample Employee database. This Database
consists of two tables Department and Employee. The Department table has two columns – Department Name and Department ID.

The Employee table has
the Employ…