Hello,

I have a sheet with my main form where i have two drop down lists, the one depending on the other. That is, if user selects the aircraft type A320, the second drop down list displays all the flight numbers with A320 aircraft type.
In another sheet i have a table which displays a number of information for those flights. Column A has the flight type, column B has the flight number and C,D,E,F etc have the number of different items that need to be loaded for that flight. My question is, how can i, in my main form, when i select from first drop down the aircraft type and second the flight no, the correspoding row to appear in my main form?

your help is more than appreciated.
Thanx