* Problem creating a query

[k0065126]

I wish to create a query showing all names which have been used in official records for my ancestors. To do this I have created an attribute called 'Name Variant' which allows me to enter the name recorded, and the date and place of the record.

I modified the 'Qualifiers for Names' standard query so that I have column headings called 'NAME:SURNAME_FIRST', 'Name Variant' and 'Name Variant Date'. In Rows I have 'Exclude if %INDI._ATTR-NAME_VARIANT% is null'.

Unfortunately if a person has more than one name variant the query only produces one row for that person.
Is there a way of getting the query to output one row for each name variant for a person, or can I achieve what I want by some other method?

I did try creating an Event but this does not seem to allow me to add the variant name as a field.

Thanks in advance,
Viv

ID:4003

[Bilko]

Hi Viv,

You could find which of your people have more than one name variant by copying the 'Name Variant' (& date) columns and modifying the expression like this -> NAMEVARIANT[2] for the second column(s). This will show you the second occurance for each person. If there are people with more than 2 variants, just add more columns with relevant numbers in brackets.

Unfortunately, I don't think you can get separate rows for each name variant but I'd be interested in finding out if this can be done.

Hope this helps

Bilko

[PeterR]

FH version 4 allows you to output a separate row for each attribute value resulting in potentally many rows per person, provided you use a Fact Query.  I've just uploaded a simple example which may help:
http://www.fhug.org.uk/cgi-bin/index.cg ... ies&id=103

[Bilko]

Thanks Peter - I've learnt something else about FH4. I'll have to try a few more of the variations on queries.

Bilko
[smile]

[k0065126]

Many thanks to Bilko and PeterR. I have tried the suggestion by Bilko which has helped me to understand more about queries, but the example provided by PeterR is exactly what I wanted.

Thanks again,
Viv