report from multiple tables

[nlo]

Hi all

Does anybody knows if is possible to create a report that combines data from 3 different tables?

Explain:

I have a database with some tables, three of them are t_tasks, t_services and t_various. Each of these tables has, among others, the following fields: operator_ID, date, job_description, work_hours, cost. What I need is to search for an operator and to produce a report categorized by a) job_description and date, with the data from the three tables.

Is this possible? Any help will be valuable...

Thanks

nlo

[RalphL]

It is posible if you have relationships between the tables. It is difficult to say much more without a lot more detail.

[nlo]

Hi Ralph, thanks for your answer

The database has also a table, t_operators, with the standard data of the operators (operator_ID, name, address etc). Each one of the t_tasks, t_services and t_various tables has a relationship with t_operators via operator_ID. If you need more info let me know.

Thanks