On Saturday 11 March 2006 04:30 pm, Mechtilde Stehmann wrote: > Hello, > > SOTL schrieb: > > Hi All > > > > I hope I am not asking a question that is obvious. I did check "How-Tos" > > and did look in the instructions but I did not see the answer. > > > > I have two test data bases: Test_Database-1 and Test_Database-2. > > > > Test_Database-1 has COMPANY-NAME, ADDRESS, CITY, STATE, ZIP for a small > > test set. > > > > Test_Database-2 has COMPANY-NAME, DATA-LIST-1, DATA-LIST-2 for some of > > the companies in Test_Database-1 but not all companies. > > > > I would like to sort select companies from Test_Database-2 and form a > > table of only those companies data and address including city and state > > into a table which may in futire test be used in some form of mail or > > email merge. > > > > The issue is I have no idea of how one opens both Test_Database-1 and > > Test_Database-2 so that one may select certain fields but not all fields > > into a table. > > > > I can open Test_Database-1 and Test_Database-2 in two windows but what I > > am speaking of would be into one window. > > > > Any help would be appreciated. > > Why do you use two databases and not two tables of one database? > > Mechtilde >
The current set up is a test set up so what you suggest is doable of course but being a test set up it is testing for some thing that is not doable. Look at it this way, you would like to connect to a commercial database where some firm or company inputs thousand and thousand of inputs in a hundred or so fields most of which is useless to you but that is the way the data is placed in the commercial database so what you need to do is connect and access only the fields you need. Now let this be data that changes daily, weekly, monthly et. For example daily sales data or inventory data or parts identification or stock price data. NOTE: In ALL of this data you have NO WAY TO INPUT DATA only access the data.This is an example of the type of data that one would in a real world setting be used place of Test_Database-2. Now on the other hand you have data such as client contacts et that have contact name and phone numbers et that is particular to your needs. This is data that you CAN and DO INPUT and that you CAN and DO MODIFY to suit your needs. This is an example of Test_Database-01. Now futher lets assume that Test_Database-2 is located on a server and is something like MySQL, PostgressSQL et. Then one is going to have to use a connector like JDBC or ODBC to access this data. Assuming that Test-Database-2 is located on a server then it can be you and it are on a local network and local server in which case the test I ran last week with Samba performing connections between the 5 different boxes A, B, C, D, and E become applicable and provide the needed connections. There is another possibility and that is that the server data is not stored on a local network but is on a web server. Then at that level you would be connecting to commercial data say supplied by the likes of Dow Jones [bad example as they are not agreeable people but you get the idea of the type of data] and personal data. One could take this to an even more logical conclusion and have commercial data [say from the likes of Dow Jones] from the web, corporate data from the local network and personal data from your own computer. You see with out the ability to connect to a number of different databases then OpenOffice database is quite useless because the data comes from a number of different sources. SOTL --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
