Developing projects for the aviation safety and the airline industry in general involves juggling a lot of large tables with total record numbers running into thousands or tens of thousands. These tables could be general information such as world languages and countries, or standard reference tables from international organisations such as ICAO, the FAA or EASA that serve as reference or working registers for aviation applications.
What this means, is having to load these tables into a form (specifically select boxes) for data entry and some applications I have worked on require more than one of such select boxes containing thousands of records each, thereby slowing increase the page load times.
This tutorial is a simple solution I came up with as a simple workaround to this problem. Instead of directly populating select boxes for each required field, we replace them with hidden controls. Select boxes are best used for submitting numeric values selected from a group. You can check these tutorials out to have a deeper understanding on how these components work, as they will be used in this tutorial.
Algothrim