I have a table with 5300 unique records [Unit::] but with several of them are located in the same buildings.
I did not create a table for [Buildings::] but would like to do that now.
The idea I have is to go through all records in [Unit::] and give it a (id_Building) number.
However, as some Units are in the same Building, I would like to run a search for each (unit) and give each record in the the found set the same (id_Building)
However, I seem to keep get stuck.
Any help or suggestions are much appreciated.