Hi all,
I use vb.net, sql server 2005. My boss want to join many database to crystal report and print.
I have main database call A, want to make centural 3 tables. Database A has (funtionA, SystemA, CompanyA, UsermasterA, AccessRightA), 5 tables and relation.
Other database call B,C,D,E,F many database .....have same tables structure if B call (UsermasterB, AccessRightB), C call (UsermasterC, AccessRightC),etc ... only 2 tables(UsermasterB, AccessRightB) ,no 3 tables (funtionB, SystemB, CompanyB).....
The main database A table company has a field call dbname, my boss want to store the real database name, then
one database will one record. In this case will A,B,C,D,E,F 6 records will store.
My form has one combo box will load all of company records, user can select one company or not select will print all of
company data. If user select B, then i want to database B tables(UsermasterB, AccessRightB) join Main database A tables
(funtionA, SystemA, CompanyA) to print information. if not select database B tables(UsermasterB, AccessRightB) join Main database A tables
(funtionA, SystemA, CompanyA) , database C tables(UsermasterC, AccessRightC) join Main database A tables
(funtionA, SystemA, CompanyA) ...etc continue no database.

In vb.net how can i do, question 1. how to store many join database tables, i can use many dataset, datatable or tableadapter ?
question 2. how to store many join database tables in crystal report?

that mean mainly want to centural fix some of tables (function table, system table) in main database, because every table need this.
After other database only need to join (function table, system table) then will easy to control.
And my company will build one database per one sub company. AccessRight table is per company user also different.
He want to wirte a program to print all of company (AccessRight table) data.

Thank you all of reader first, because i think this isn't enable mission or in vb.net.
But I still hope all reader can give some of idea to me if you understand my question.