>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?
>
>Anyone know how to do?

Doesn't sound like a good design. What happens when you get to 'G'. 'H' etc. Would it be possible to use just one actual database with table fields to indicate which 'virtual' database each record belonged to.
IAC, you may have more luck posting this in the SQL section......