I have two tables linked as a 1 to Many relationship. The first table is call Departments and the second table is Equipment. One department can have many pieces of equipment. Now what I want to do in a third table is to set it up in such a way that when I choose a department that only the equipment related to that department shows up when I click on the drop down for the equipment field. There are other tables with similar relationships, example I have a Preventive Maintenace field that is one to many with the Equipment field, again one piece of equipment can have many PM's related to it. I am working on a PM database for my company and its all mapped in my head I am just having issues making it come to life in access. BTW I am using access 2003.

Thanks for any help!

percom74,

A couple of suggestions. Make a picture/data model of what things are involved in your business. Get a look at the BIG picture and how things interrelate.
Here are a few links to help:

http://www.youtube.com/watch?v=k-gpb_rPjSk (Crystal video --Excellent start)
http://www.youtube.com/watch?v=2dTT8lgWRtk&feature=related (free video)
http://www.fontstuff.com/siteindex.htm#access (dynamic reports etc)
http://r937.com/relational.html (normalization info - important for design)
http://www.databaseanswers.org/data_models/index.htm (sample models)
http://www.allenbrowne.com/casu-22.html (very good guide)