I'm new to Zoho so please bear with me. Here's an example of what I'm trying to do.
I have a "Employee Form" where you can add employees and general information about them.
I have a "Vacation Form" where I can add vacations. This form is contains a lookup field connected to the name field on the employee form plus fields for start and end dates.
I want to have a Report that pulls selected information from both forms. For example employee name, phone, email, and vacations(there could be multiple vacations per employee).
What's the best way to do this? Thanks!