Addresses used with a particular place
Posted: 12 Apr 2019 13:33
I'm wondering whether there is any way to show a list of Addresses associated with Places. One place I'm thinking about is in the Places property box. For most of my places, the Main tab has a large and unused Notes field; or an extra tab listing just the addresses might be an alternative. However, I can't see any way to do this - have I missed something?
As a workaround I've created a Custom Fact Query:
Columns are:
Place (%FACT.PLAC>%) (Sort Ascending)
Address (%FACT.ADDR%) (Sort Ascending)
Fact (%FACT%)
Person(s) (=GetRecord(%FACT%))
and for Rows I have specified Add unless %FACT.ADDR% is null
This produces a list of Places, with related Addresses next to them, all in alphabetical order. There's a separate line for each fact using the address, but that's OK as long as I don't try to edit the addresses from there, since the changes wouldn't be applied to every instance.
However, I've come across a minor problem with sorting the results. If I want to see the results sorted by Address I click the Address column heading. However, if I then want to go back to sorting by Place and click that heading, the Addresses relating to a Place are no longer in alphabetical order. I know I could just run the query again, but I'm just wondering if I've done something wrong.
Thanks for any help.
As a workaround I've created a Custom Fact Query:
Columns are:
Place (%FACT.PLAC>%) (Sort Ascending)
Address (%FACT.ADDR%) (Sort Ascending)
Fact (%FACT%)
Person(s) (=GetRecord(%FACT%))
and for Rows I have specified Add unless %FACT.ADDR% is null
This produces a list of Places, with related Addresses next to them, all in alphabetical order. There's a separate line for each fact using the address, but that's OK as long as I don't try to edit the addresses from there, since the changes wouldn't be applied to every instance.
However, I've come across a minor problem with sorting the results. If I want to see the results sorted by Address I click the Address column heading. However, if I then want to go back to sorting by Place and click that heading, the Addresses relating to a Place are no longer in alphabetical order. I know I could just run the query again, but I'm just wondering if I've done something wrong.
Thanks for any help.