What should I do to see information about companies A and B without having to change the ODBC and refreshing tables and formulas every time?
Changes in sort orders, relationships, graphs, formulas, queries and reports may be required. Assuming an ODBC Data Source Name is already pointing to company A, setup a new ODBC System DSN to point to company B (you may name it anything you want). Modify the Importing properties of each table, joining the same tables in each database (give each table a different Table ID). If the IDs (i.e. Customer ID, Salesperson ID, etc.) are not the same for different companies, you may define filters for Table ID and place them in all queries, reports and everywhere else you think is necessary. If same IDs are used in different companies, you will have to define sort orders and relationships using ID + Table ID (company ID). All other objects (graphs, queries, etc.) may have to be analyzed and modified. Filters can still be used for some analysis.
Related Questions
- What should I do to see information about companies A and B without having to change the ODBC and refreshing tables and formulas every time?
- What is the best procedure for switching hosting companies, to ensure there is never a time when people can reach my site?
- Can Time for Paddington get funding for us from companies?
