Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!van-bc!rsoft!mindlink!a513
From: Rick_Vandenberg@mindlink.UUCP (Rick Vandenberg)
Newsgroups: comp.os.msdos.apps
Subject: Re: How to link databases in dBase III ?
Message-ID: <4756@mindlink.UUCP>
Date: 11 Feb 91 00:23:24 GMT
Organization: MIND LINK! - British Columbia, Canada
Lines: 30

> chaim@eniac.seas.upenn.edu writes:
> 
> 
> I work with a friend who maintains 5 mailing lists on 5 separate databases
> using dBase III+.  He asked me to try to help him set something up so that
> the 5 databases can be linked in such a manner that he can search all of
> them and print out the mailing labels from all of them as if they were
> one database.  Does dBASE III+ have some link command?  If not, can it
> be programmed in?
> 


The only way to make commands such as LABEL or FIND or such work on different
databases is to combine the into one file using APPEND. eg-

USE FILE1
COPY TO ALLFILES
USE ALLFILES
APPEND FROM FILE2
APPEND FROM FILE3
APPEND FROM FILE4
APPEND FROM FILE5

This gives you a file (ALLFILE.DBF) that contains all the data. If you wish,
add a field that indicates which file a particular record came from. If you
want a more detailed description of how, or a sample or something, just say so.
Bye the way, why does your friend have 5 separate mailing lists?

Rick Vandenberg,
Vandenberg Systems Research