home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases
- Path: sparky!uunet!dcatlas!joet
- From: joet@dcatlas.dot.gov (Joe Trott)
- Subject: Re: Simple Question on Paradox
- Message-ID: <1992Aug27.202935.26767@dcatlas.dot.gov>
- Organization: U.S Dept. of Transportation
- References: <6717@tekig7.PEN.TEK.COM>
- Date: Thu, 27 Aug 1992 20:29:35 GMT
- Lines: 26
-
- naren@tekig5.pen.tek.com (Naren Bala) writes:
-
- >For those of you who are experts at using paradox, I had a simple question.
- >I have started using paradox. Can anyone tell me how to merge 2 tables into
- >one table ? Any help will be appreciated.
-
- More information is needed. Do the tables have the same structure? If so,
- you can use Tools|More|Add.
- Are you adding the fields of one table to the second? Create a query using
- an example element to link the tables. See chapter 4 of the Paradox Users
- Manual about joins, and details on keeping repeating values and dealing with
- missing values. After you press Do_it! and get an Answer table, use
- Tools|Rename to save it as a permanent table.
- If this merged table is one that will be recreated _temporarily_ for reports,
- based on the second example above; create the table as above, then Empty it
- *BUT DO NOT REMOVE THE TABLE*. Create your reports using that table and
- save them. Then, in the future, each time you create a new Answer table,
- copy the desired report from the empty table with the same structure to
- Answer and run it. The only purpose for the empty table is to hold the
- report definitions for the structure you desire, but this is a necessary
- purpose.
- Hope this helped; feel free to ask if you need clarification or more
- information.
-
- -JTT
-
-