I have two tables, "Style" and "Color". The first has two fields, "Student" and "Type of shoes", with the names of students and their preferred type of shoes respectively. The second has two tables, "Student" and "Color of shoes", with the names of OTHER students and their preferred color of shoes respectively. I need to display only students whose preference is black >or< heels (display their name, preferred style, and preferred color). They must display on one screen. I have tried to do it through creating a select query, but I am not sure about what relationship should be between the two tables, since they are not really related. Also I don't know what criteria to use. Could anybody help?