* Work with Data.......Places

[Shiriki]

Have had a number of sessions over the past few days tidying up my Addresses. and making better use of additional columns to enable better sorting of my data.
In doing so I have been transferring information from the Place Field within the relevant Fact against an individual and so on and editing entries held within Place.
When opening Work with Data>Addresses things are looking a lot tidier and logical.
However when opening Work with Data>Places I am presented with quite a lot of issues to resolve which will require double checking using the Merge facility and so forth.
I have noticed that I have a number of Place entries which now have a number of 0 under the column Used as a result of my previous editing etc.
Highlighting the entry and using Where used does not return anything, so confirming my belief these entries are redundant.
No matter how hard I try I cannot seem to be able to delete these entries and thus remove them from the compiled table.
It seems one cannot edit out the entire entry within Place. you have to leave one character in the field otherwise for an edit to be accepted whereupon it will be shown in the table the next time it is opened.....
I think that an option is to Merge these unwanted entries with another one which one wants to keep using the latter as the master....I have tried this and the entry one wants to keep does not increase within the Used column and the redundant entry disappears.
Unless I'm missing something this is not particularly elegant and open to making errors.....

Any help would be welcome to put me back on the correct path (if there is one).

Shiriki

[LornaCraig]

Hi Shiriki,

Using the Merge option will work quite well, but if you just want to delete a Place you can do this in the Places tab of the Records window. Just select the Place and hit the delete key. You will be asked to confirm that you want to delete the record completely.

[tatewise]

Yes, when reorganising Place Records (remember that under the hood they are now Records) some can have no links to Place fields and Used is zero.

Those Records are not automatically deleted, because it may only be temporary, and you would not want all the Lat/Longitude, Notes, and Media discarded.

Merge is one solution where appropriate, either in Tools > Work with Data > Places or in the Records Window on the Places tab using the Edit > Merge/Compare Records which offers more control over merging the fields. Alternatively, in the Records Window you can simply Delete the redundant Place Records.

All those options seem to behave well and I do not understand your problem in the penultimate paragraph. The Used count will become the sum of the Used counts of the Merged records, but since in your example the redundant record Used count was 0 there will be no change.

[Shiriki]

Thanks for the quick responses.....yes I have now realised that one can delete such redundant entries via View>Record Lists>Places.....i thought there might be a way from the Work with Data tables directly.
Sorry if my comment in my initial post (extracted and shown below) caused confusion:
I have tried this and the entry one wants to keep does not increase within the Used column and the redundant entry disappears.
Perhaps I did not make it clear that one did not want the entry under Used to increase and I had confirmed that this was indeed the case...so all was well with that methodology.

Thanks again.

Shiriki