I fixed data and queries so I could get records.
19 files for different filter criteria! What a maintenance nightmare! How does each user get a new version of the database? Review: http://forums.aspfree.com/microsoft-...ue-323364.html
Learning about data relationships is essential if you want to manage and modify. Your choices are to learn or pay but we really can't get you through the basics in thread discussion. Need a class or good book if you can self-teach. It may seem daunting but just takes a bit of time as learning anything new does.