AboutRichard Rost Expertise I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Education/Credentials I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
Hi, i send you a question earlier today, but i forgot to attach the image. Here it is.
Answer I see your relationships now. I think you might be confusing Access with too many related fields.
While it's POSSIBLE to have multiple linked fields, it's BEST if you only have ONE: a primary key and ONE foreign key. You don't need to copy all of that data between tables.
For example, let's say you have schools, students, and classes.
Your student table would have a StudentID and a SchoolID.
Your classes table would have a ClassID and a StudentID, but it does NOT need a SchoolID because you can look that up through the student table.
Try removing some of your redundant fields and see if it helps. Also, see this tutorial:
It sounds to me like you need to learn a little more about the basic concepts of building a Relational Database, and making relationships between two tables.
Watch this free tutorial on my web site for help with this topic:
P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.
)