A
Aviator
Getting closer on my issue from before. Final barrier. I have a Parameter
query form that has one list box to select aircraft type, and 25 check boxes
that relate to 25 fields in the database that has an airplace interior broken
into catergories. I.E. Seats, Carpet, Windows, Galley,....etc. When work on a
job is complete, the job number is filed in the database and the catergories
that were worked on are selected, sometimes 10+ check boxes are selected for
one record. My parameter query will pull records that match exactly what I
enter. I want it to be more flexible. If I select a lear jet, and select the
"seats" check box, I want all record from a lear jet that we worked on the
seats regardless if we changed the carpet as well.
query form that has one list box to select aircraft type, and 25 check boxes
that relate to 25 fields in the database that has an airplace interior broken
into catergories. I.E. Seats, Carpet, Windows, Galley,....etc. When work on a
job is complete, the job number is filed in the database and the catergories
that were worked on are selected, sometimes 10+ check boxes are selected for
one record. My parameter query will pull records that match exactly what I
enter. I want it to be more flexible. If I select a lear jet, and select the
"seats" check box, I want all record from a lear jet that we worked on the
seats regardless if we changed the carpet as well.