Create monthly report by view

Hi,

I am just beginner in drupal. I need someone to help me to get out of this problem that i can't handle.
Here is my simple table (sale_orders, tickets, nodes) that are used in the project. We have developed this project by me and my friend. My friend had developed view that used to show tickets information and node by using views relationships. His custom module name is custom_search, in his custom_search module he also implement views_data in custom_search.inc.
And I also need to develop my custom module to show sale_orders and tickets information with view by using views relationships to join sale_orders and tickets, my custom module name is sale_order_view, in sale_order_view.inc I also implement views_data() function.
The problem is that when we add relationships we can see filter dropdown box, in that I can see my friend datatable name, (tickets table) and my datatable name, sale_order_ticket table. But those tables fields are can not be seen. Where are they gone?
When disable my custom module (sale_order_view), I can see datatable name (ticket table) and i can also select its fields and it is work.

My question is how to solve this problem? And Can we use view_data function twice in me and my friend module?

Thanks in advance