i would like to relate my table1 with table2. How can i do that? I was told to play around with the id?

---

Reply from Richard Rost:

Relating tables isn't something that I cover in the Beginner series. You'll have to wait until Expert 1, or you can pick up my Access 201 class. It's for Access 2003, but the material translates just fine to 2010. I also have a whole seminar on Access Relationships. In a nutshell, it's not hard to relate multiple tables together, but unless you understand the underlying theories, you'll probably do it wrong. It's more than a quick 5-minute answer to your question.