FTM - complex query

Is there a capability within FTM or some secondary product that would
perform complex queries within the FTM dataset? For example, I would
like to search for married names, or sets of specific siblings, or
individuals who were born at a specific location and had an uncle named
'Robert'.

Kerry Raymond...

No. And it's one of the biggest drawbacks to FTM in my opinion.

You can select people based on individual characteristics (born in England,
died before 1900, etc --- albeit with some limitations), but you can't
select based on relationships (mother called Mary, is a twin). Nor can you
produce reports easily using relationships (other than some built-in
reports). Using Custom Report with careful selection of individuals to be
included and information to be displayed, you can sometimes produce reports
that are a sort of poor man's query output, but if you have any experience
in relationship/object/XML database query, you will be very disappointed!

Certainly you can't say something like ...

WHERE P.parent.parent.child.givenName = "Robert"

Hugh Watkins...

but upload a gedcom to World Connect and get another view point
or via PAF make your own html site and use web-search

Or import a ged into Gustodian 3

Hugh W

Jim

Charlie Hoffpauir...

Jim,

Since you include "secondary products", I'd suggest importing your FTM
dataset into RootsMagic (which will read your native file directly)
and making your complex queries from within RM. And if you get really
complex (too complex for RM to handle) since the RM data sets are not
"proprietary" as FTM is, you can always open the data in a database
program and create custom queries via programming.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

Paul Blair...

TMG has some query strength, to be sure. But, to get the full SQL life,
export FTM as a GEDCOM, import it into Legacy, and you have the full
power (!) of MS Access at your fingertips. You can knit a query to do
just about everything your data will allow then...