[RESOLVED] Auto Update <select> options based on other <select> options in the form
Can anybody help me with this? or at least point me in the right direction? If you have any questions just let me know!
Basically I have a system that has 8 users who each have their own station. Every few months they switch stations. So I have a table to holds the user and what station they are assigned to.
Unsure what you mean by "have their own station" and how exactly "switch stations" is determined? And "where I can choose the station they are assigned to" needs some clarification perhaps also. Are you talking about multiple users on same/different machines/and/or different logins? It sounds to me like you are looking for a server-side solution actually.
That page doesn't do anything right now, but I want it so those dropdowns cannot ever possible have the same # selected. So if the first dropdown I choose station 2, I want the rest of the dropdowns to remove that option.
It sounds to me like you are looking for a server-side solution actually.
Here is a picture showing kind of how it should work. In the first section, all 8 dropdowns show all 8 options. In the second section the first option has #3 selected so it no longers hows up in the rest of the dropdowns. In the 3rd section you have 3 select in the first dropdown and 6 selected in the next dropdown, so both of those options are removed from the remaining dropdown menus. I want to get this to happen without reloading the page.