I've been given the table tblAltn. It lists destinations for aircraft and the alternate airports. These are different for various aircraft either the runway not long enough or the bearing strenght too low.
I made a very simple form frmAltnSel to get me started and get my bearings. I want to filter the table by destination and aircraft type.
For example for 744, destination EHAM the alternates are EHRD EBBR EHBK EDDG where the B737 has the alternates EHRD EHEH EHGG EBBR.
I started with the TRUE statement in the criteria field of the 744 column in the Query3 design.This gave the wanted result. Changing the criteria in the 744 column to false and True in the 737 column gave a not wanted result.
I think the problem lies in the fact that the frmAltnSel has the same input as the column 744 however both being a different parameter. Text versusYES/No field. I tried iif statements but seemto be lost at the moment how to make this query work.
Any help to get me started would be welcome