So far I am in Access 203 video. What I have seen so far is that you only created just one relationship table right?  I haven't seen more of the table relationships yet.  What I have found out is that it is very important that the Forms are correctly designed right or else it's not going to work with all the other tables that are related to the fields.  Right?  I'm sure there are more than that but basically, I have noticed the importance of designed the form and its related field links from each of the different tables.

---

Reply from Richard Rost:

It's been MANY, MANY YEARS since I recorded these classes, but I believe at this point we've only set up ONE relationship between the Customers and Contacts. Yes. There will be more coming in future lessons.

Forms are pretty easy to change. The hard part is making sure your TABLES are set up properly from the start. This isn't always easy, especially for beginner users, because as you learn more you learn BETTER ways of doing things... but I can't just jump in and show you the BEST way first because it's pretty confusing. So I like to show you the evolution of how databases were built, moving from simple flat-file, one-table setups to more complex relationships as time goes on.

That's why I like to tell people not to start building any serious database projects until you've FINISHED my entire Access series. Many times people get through, say, the first couple 200-level classes and then start their projects... and then by the time they get to the 300s, they're like "DOH! I should have waited."