Redudent info in Combobox

[JoeyB]

Couple of weeks ago I also posted a question about my database.

I got 103 airports, and data for over 28 years. For example types of Aircraft movements(domestic, regional, international)

Airports got their AirportID, years got their YearID. To connect the data to the airports and years I put the AirportID and YearID next to the data. Now the data is connected to the airports and year.

I made a query for AirMovements and eventually a Form.



What I would like to achieve in this Form, is that the user would select an airport, a year and then the data would appear what he is requested. But what happens in the Comboboxes is that for you have to look up the airport in year 1994-95 for example.

Instead of this, I rather have 103 airports in the combobox and next to it a combobox with 28 years.

Gratitude in advance

[June7]

Not quite sure about your data structure.

Maybe use DISTINCT qualifier.

SELECT DISTINCT AirportID FROM Airports;

[JoeyB]

Not quite sure about your data structure.

Maybe use DISTINCT qualifier.

SELECT DISTINCT AirportID FROM Airports;

Works, future looks a bit brighter now ;p