Jeffro,

I wasn't being rude really (you'd know if I was!) BUT you really do need to think about your database design I am serious about you not being clear on Referential Integrity and Primary Keys - you will spend a lot of time going round in circles if you do not get a good grounding in those topics.

Check out the tutorials in the Access help on RI and Keys. A good book would, I think, help you a lot.

Basically your RI problems are because tables are related so that fields in one table must take values from fields in another table.

Structured design (and Normalisation to third normal form if possible) is highly desirable. Do a search on here (and the rest of the Web) for Normalisation. Might be useful to you in explaining the concepts.

Cheers,

Paul.

Sorry, if you felt flamed...