Consolidate tables from different companies

casanova

hi all
is there possible that we can consolidate 1 same table from different companies?
lets say i want to show all of the customer list from 1 Database (more than 1 company inside database)
i need to create report consolidation from several companies

David_Singleton

Yes this is what the COMPANY function is all about. Just create a new table with the primary key Company,Customer No." set it common to all companies and populate it with the necessary data.

Alex_Chow

You mean CHANGECOMPANY right?

David_Singleton

Alex Chow wrote:

You mean CHANGECOMPANY right?

I certainly do :oops:

casanova

David Singleton wrote:

Yes this is what the COMPANY function is all about. Just create a new table with the primary key Company,Customer No." set it common to all companies and populate it with the necessary data.

do i need to create something in SQL server before do this?
how to populate data in this single table?

einsTeIn.NET

No, you don't need to change anything in SQL Server.

What is the purpose of this list? Is it a one time task or do you need it recurrent? Should it be some kind of print-out or do you need it in e.g. Excel as well?

casanova

einsTeIn.NET wrote:

No, you don't need to change anything in SQL Server.

What is the purpose of this list? Is it a one time task or do you need it recurrent? Should it be some kind of print-out or do you need it in e.g. Excel as well?

i want to create report that will show all the customer from 1 database
i dont think my users want to use excel

einsTeIn.NET

Well, then you could just create a Report and use function CHANGECOMPANY to read the customers from other companies. You don't even have to create an additional table.

David_Singleton

einsTeIn.NET wrote:

Well, then you could just create a Report and use function CHANGECOMPANY to read the customers from other companies. You don't even have to create an additional table.

:thumbsup: