Hello, New user here, so I'm sorry if this problem has been addressed before.
I am creating a form that has a dropdown menu consisting of data from a table I have created.
There are 4 columns in this table: "Model", "Total Cooling", "Make", "Net Cooling".
When the required row in the dropdown menu is selected, I have another field in the form that shows only the "Total Cooling" part, which is then used for some calculations elsewhere in the form.
The problem I am having is that I also need a field that references the "Net Cooling" part of the selected dropdown field, so that further calculations can be made from that field in yet another part of the form. Whenever I reference the dropdown, it only shows up the "Total Cooling" part in all fields that link to it. Is there any way of specifying exactly which column I can reference from the dropdown that is selected?
Thanks in advance, and I am aware that it will probably be something really simple that will embarrass me!!! haha.