Ive searched and haven't found a non-vba solution.
I have one form that has a combo box with pilot names, there is a possibility of up to four flight codes (at least one). The manager requesting my database wants to be able to select multiple fly codes per pilot instead of a new entry for each one. These are entered by date and I am running a query that shows a pivot table with dates and codes sorted by pilot.
let me know if there is a easy way to do this. I have seen sub forms but i don think that will work. thanks in advance