After you have all the records in the database is there a way to assign a building to each of the records and have an equal number of records per buildin?
This is a screen shot of what I am trying to do. I put in Building No 4 it looks up building 4 and it gives me Denbow City. I would like to automate this process by giving me about the same number of records for each building. I have around 460 records.