* Source Queries

Homeless Posts from the old forum system
Locked
avatar
pjbwilson
Silver
Posts: 7
Joined: 20 Sep 2003 12:50
Family Historian: None

Source Queries

Post by pjbwilson » 10 Oct 2006 00:16

I hope this has not been covered.

I am trying to write a query that will list all individuals and all sources, or source types.

So there will be a few lines of sources per individual.

Is this possible? Does anyone know how to do it? Any help would be greatly appreciated.

Thanks,
Peter

ID:1904

User avatar
Jane
Site Admin
Posts: 8441
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Source Queries

Post by Jane » 10 Oct 2006 08:38

I think you would need to use a report rather than a query. You need multiple lines per record, which means you can't currently do the job with a query.

If you were just looking for instance to see what the sources were for BMD events you can do that with a query, but not a blanket all sources for all people in queries. I think there is one in the Query store for that.

Obviously you can already do a query for a single person using the standard Sources for Given Record Query, and see the Number of Links per source using the Record Links Query.

Locked