I have to design the database as stated due to the teacher requiring certain parameters. This is for a college Access & SQL course with a teacher who wrote the text, is ready to retire, and doesn't teach you anything but says look it up in the chapter or on the net! If you want to laugh at a college text book read "Customizing Access Databases with VBA and SQL" By Steven Gramlich