You are here:

Using MS Access/forgot to attach the image..

Advertisement

Expert: Richard Rost - 7/8/2009


Question

screenshot tabels and
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:

http://599cd.com/tips/access/relational-tables?key=AllExperts

I also spend a whole hour in my Access 201 class going over table relationships:

http://599cd.com/site/access/access201?key=AllExperts

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts


Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Access Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

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.

http://www.599cd.com/Microsoft_Access_Tutorial?key=AllExperts

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts

Richard 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, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

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

©2012 About.com, a part of The New York Times Company. All rights reserved.