Our office standards associate the door number to the room number. I am looking to assign a parameter value to the door tag that follows a sequence but these values would also align to the room number. Basically if a room number is 100, then I would like my doors to be 100a, 100b, 100c, and so on, until it runs out of doors within that room, then it would go to the next room number 101, so we will get 101a, 101b, 101c, and so on. I hope this makes sense.
So far I was able to create the basics. The sequence has been created and the room number values have been acquired. How would I link the two together to achieve what I outlined above?
I am sure someone knows the answer here.