I have a uniform database that has an Employee Table, a Parka Table, Position Uniform Link Table and a Uniform Table. The Employee Table just list Name, Location, and the Allowance they receive for that year. The Parka Table has the Employee Name, Parka Item #, & a Yes/No box that is checked if they had ordered the item the year before. The Position Uniform Link Table tells what uniforms that person can purchase according to their position. The Uniform Table lists all of the uniforms that are available from that company. I have a query that pulls everything together for a person, except I don't know how to utilize the Parka Table so that it deletes off the item, and only that item, if the box is checked. The Parka Item # is 7780. So how do I get Item 7780 not to print for a person, when the order forms are produced?