AnsweredAssumed Answered

Looping difficulties

Question asked by fpreidel on Oct 22, 2018
Latest reply on Oct 22, 2018 by user19752

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.