General search in Legacy 6.0

[lars]

I'm running Legacy 6.0 (basic version), and can't figure out how to do a
general search throughout a given family database file. For example, I
wanted to find the word 'Litchfield' (a place name) anywhere in the data.

As best I can tell, you can only search specific fields, which seems
pretty limiting. I don't see that the deluxe (pay) version does any
more, according to the features list.

I used to be able to do a general search in Reunion when I was using it
on the Mac - surely there must be a way to do so in Legacy!

Any suggestions?

Lars

[Gjest]

On Tue, 25 Oct 2005 14:43:53 GMT, lars <[email protected]> wrote:

I used to be able to do a general search in Reunion when I was using it
on the Mac - surely there must be a way to do so in Legacy!

Afraid not. Legacy's underlying database is MS Access, an SQL database.
Any searches must be column specific. The program could search every
column individually for you (in the background), but that could get
quite ugly and time consuming. There are hundreds of columns.

Any suggestions?

Export your data to a GEDCOM and open it in a text editor. Then search
the GEDCOM for the text you are looking for.

--

Dennis

[Rich256]

"lars" <[email protected]> wrote in message
news:[email protected]...

I'm running Legacy 6.0 (basic version), and can't figure out how to do a
general search throughout a given family database file. For example, I
wanted to find the word 'Litchfield' (a place name) anywhere in the data.

As best I can tell, you can only search specific fields, which seems
pretty limiting. I don't see that the deluxe (pay) version does any
more, according to the features list.

I used to be able to do a general search in Reunion when I was using it
on the Mac - surely there must be a way to do so in Legacy!

Any suggestions?

Lars

If it is place names that you are searching you can call up any individuals
information and click on the down arrow next to any of the placename fields.
This will bring up a list of all place names in the record. Then if you
select one of the place names you can click on list and see what individuals
use that place name. Also a convenient way to globally change a place name.

However, if the name is in notes the only way I have been able to find such
a thing is to made a GEDCOM and use a word processor to find the word.

[Bill Harrison]

Hi Lars and Listers

Just copy the Legacy file and Then change the extn to mdb and open in Access
....

regards

Bill



----- Original Message -----
From: "lars" <[email protected]>
To: <[email protected]>
Sent: Tuesday, October 25, 2005 3:43 PM
Subject: General search in Legacy 6.0

I'm running Legacy 6.0 (basic version), and can't figure out how to do a
general search throughout a given family database file. For example, I
wanted to find the word 'Litchfield' (a place name) anywhere in the data.

As best I can tell, you can only search specific fields, which seems
pretty limiting. I don't see that the deluxe (pay) version does any more,
according to the features list.

I used to be able to do a general search in Reunion when I was using it on
the Mac - surely there must be a way to do so in Legacy!

Any suggestions?

Lars

[Paul Blair]

Bill Harrison wrote:

Hi Lars and Listers

Just copy the Legacy file and Then change the extn to mdb and open in Access
...

regards

Bill



----- Original Message -----
From: "lars" <[email protected]
To: <[email protected]
Sent: Tuesday, October 25, 2005 3:43 PM
Subject: General search in Legacy 6.0



I'm running Legacy 6.0 (basic version), and can't figure out how to do a
general search throughout a given family database file. For example, I
wanted to find the word 'Litchfield' (a place name) anywhere in the data.

As best I can tell, you can only search specific fields, which seems
pretty limiting. I don't see that the deluxe (pay) version does any more,
according to the features list.

I used to be able to do a general search in Reunion when I was using it on
the Mac - surely there must be a way to do so in Legacy!

Any suggestions?

Lars



If anyone wants to go this way (using Legacy data directly from MS

Access) here is the table list with some idea of how each is used:

Legacy 4 (L4), Legacy 5 (L5) and Legacy 6 (L6)

tblAR - address register 26 fields in L4, 27 in L5, L6
tblBP - to do with picture storage 4 fields in L4, 5 in L5, L6
tblBR - picture information 16 fields in all
tblCP - 5 fields - in L5, L6 only
tblCR - Child record - 13 fields in L4 and L5, 14 in L6
tblCS - Child status 4 fields in L4, 5 in L5 and L6
tblDM - 2 fields (possibly parents?)
tblER - 14 fields (includes events?) in L4, 15 in L5, 16 in L6
tblET - event description table. Comes preloaded with 90-some common
events. 15 fields in L4, 18 in L5, 19 in L6
tblHB - 3 fields
tblHL - 3 fields
tblHR - basic user info (compiler etc) 2 fields
tblIR - individual records 80 fields in L4, 83 in L5, 92 in L6
tblLR - location records 11 fields in L4, 12 in L5 and L6
tblMR - marriage records 50 fields in L4, 57 in L5, 63 in L6
tblMS - marriage status Comes preloaded. 4 fields in L4, 5 in L5 and L6
tblNR - surname register 4 fields in L4, 5 in L5 and L6
tblNX - 12 fields
tblRM - Reminder table
tblSR - source register 24 fields in L4, 27 in L5, 30 in L6
tblST - source type Comes preloaded 4 fields in L4, 5 in L5 and L6
tblSX - source ? 18 fields
tblTC - source certificate type Comes preloaded. 5 fields
tblTD - To-do register 17 fields in L4, 18 in L5 and L6
tblTL - locality ? 4 fields in L4, 5 in L5 and L6
tblTR - list of 133 Temples (international) 4 fields in L4, 5 in L5, 7 in L6
tblXI - deleted register for individuals 1 field
tblXM - deleted register for marriages 1 field

E&OE

Paul Blair
26 Oct 05