How to transfer the cursor's coordinates from its position on a map into a selected record in a table?

tl;dr

My project is to georeference the NSW Historical Schools database. I've linked many historic schools to near/matching Gazetteer records, but about 10% of records are 'lost in space' - they are not georeferenced correctly, or are nominally at 0,0 (long/lat). Each school has changed type over the last 150 years resulting in perhaps 10 temporal records for each school - and each record needs to be georeferenced.

In reality, most of these thousands of schools no longer exist, but they almost all appear as identifiable land parcels on 100-year old parish maps and in historical records, so an approximate spatial location for each schoool can be visualized in Manifold.

Many hundreds of schools have a long/lat of 0,0 makling it tedious to Alt-select one record amongst hundreds so it could be dragged to the correct location? Nor is it easy to drag records when the zoomed scale is small (eg 1:1m) - it can be done but is tedious with lots of map manipulation.

My challenge is how to transfer coordinates from the visualized position - the cursor position - on the map (the topo, or satellite etc) into the relevant school record, when that school record has NO attributes that could link it a spatial location.

I have georeferenced some Parish maps to get cursor position, and that would simplify visualizing the historic locaton, but this is far too complex a task, considering that each Parish may have only a handful of schools to map.

Is there an easier work-flow for copying the cursor's lat/long into selected records ?

Thanks

Greg

You can create a point in another drawing for known locations, and add information in a field that can be linked to a field of your current database (school name for example). Then do a table join between both table. This way, you can pass coordinate from the new drawing to your current DB.

Thanks vincent.

I do have a reliable identifier - [Record_ID] - for each School that I can use, so a simple matter of creating points on a new table drawing at the visualized location, then assigning to each the matching foreign key from the School (Record_ID) and join by key field - doneski.

Cheers

Greg

Quick and dirty manually: Create a point in any drawing, copy [geom] and paste it in one of the target records. Select all records pointing to this school and transfer [geom] to all selected records in the Table.

Do you really want to ruin economy only to save the planet?