I have a layout called "buildings." Each building has 7-10 doors. Our company keeps track of all the locations and details about each door. I've created a form that looks like this
Location Door Type Door Color I want to put fields under those labels and pull up the information through pop-up windows. The problem I am having is that when I pick a
1. location for the second door, the first door will change to what the second door says. Or when I choose a color for the first door the rest of the
2. doors fill up with that same color. I want each door entry to be specific and different. Is there any way to do this?