Form to add a variable number of runways for a specific airport

[ricky99]

Hello gents,
I need your appretiable help on this.
In my database there is a form to add airports and their data. This populate a table to alloow creating flight reports of my simulation flights (in FSX). I would like to add runways by textboxes. Problems are:
a. some airports have 1-2 runway (so 1 or 2 textboxes), while some others have more (a variable number of textboxes).
b. how to save the (variable in terms of numbers) runways information into a new table?

Essentialy, my target is to create a table with the name of the airports and all runways for each one. This is requested because when I create a flight report and select the departure/arrival airport, a combobox loads the corresponding runways for that airport.
Any suggestion about the completion of this task?



Many thanks guys, bye.

Riccardo

[June7]

Sounds like you have the right idea - a table that associates airport with its runways and dependent combobox for flight report record. If an airport has 2 runways then the table will have 2 records for that airport.

What do you want to use to ID the runway - the runway numbers, like: 18/36, 01L/19R, 01R/19L?

[ricky99]

Hello June7,
right, I would like to use the number of runway, but in this way: the user insert runways 18L and 18R, two textboxes load automatically their corrisponding 36R and 36L. Then the user insert one more runway (09) and in another textbox comes up the 27. So we have one airport (XXXX), with 3 runways (6 if we consider the runway directions).

[June7]

Are you talking about data entry to flight record? You want to select and save the runway directions separately? Why?

Another point to consider. Those runway designations occasionally change: 18/36 could become 17/35. Would you want to cascade the changed value out to all flight records?

[ricky99]

There are two steps, just to clarify.
First. The user insert in the DB a new airport (whether it has not already been setup), with all data (ICAO, IATA, AirportName, Lat/Lon and so on) and runways information as well. About this point it is better to treat the runway 16L as separate from the opposite one (34R) because are effectively two different runways. I wonder, which is the best way to fill the form with runways information (textboxes, comboboxes, listboxes)? Those runways are saved with all other airport information in a table.
Second. When the user complete the flight data report, he/she selects the airport for departure and the combobox lists the runways available for that airport. These data are then saved into another table.

p.s.: ... and yes, being subject to occasional changes, it would be better to consider this factor and update the flight data records accordingly.

[June7]

Normalization rules would call for two tables for airport data. One that has airport general information (name, lat/lon, etc) and one for the runway info. Use form/subform for data entry/edit.

Then a table for the flight info and another form to enter these records with comboboxes to select airport and runway.

Automatic cascade update of changed runway designation would require setting relationship between the flight and runway tables. Otherwise, run UPDATE queries to change values in flight table.