Dear all,
I have a situation like:
While registering new company in ERP software. It will create 2 new databases one for company details another one is for corresponding all the table in another database. For example I have registered a Company called Company1:
Lets check after registering this company what is happening in the SQL server.
Company details like companyid, companyname, databaseid etc will be stored in one database: And all the transaction details tables will be stored in another database, among all table GLAccount is one of the table.
Lets describe: step wise:
Step1:
After registering created database say for Database1... in this database company table say for companydetails: Fields are given below
Companid companyname datbaseid
Note: while registering any new company will be stored in the above table.
Step2: After registering company all the installation table will be stored in another database (it will create new database with company name itself) In this case second database will be Company1: (because companyname registered as company1)
In This database One table is GLAccountDetails: in this fields are
accountname,accountindex, accountnumber.
In this table there is no field like databaseid(so that we can link this table to another database table i.e company details).
My requirement is in the Dropdownlist I want to populate all the company from database1(from step1) and based on company selection I want to populate all the GL accoutnumber in another dropdownlist. How can I link these different database so that I can get the correct GLAccount details. Please help me to achieve this functionality Your help is always appreciated.
Thanks in advance.