Pop-up changing data
Hi there, I have a lists of Route Numbers, with corresponding Building Names, with corresponding Floors, with corresponding Room Numbers. I have created them all to be pop-up menus so each person can choose a specific location based on route, building, floor and room. My question is, when I change the lists I do not want it to change the data, I just want it to look it up. For example if I choose Building A, Floors 1, 2, and 3 show up. But when I choose floor 3, it changes the entire record for Building A (says there is no floor 1 anymore), when I just wanted it to reference it. How would I create a pop-up list that does not edit the data?