Hi,

I am really confused when I learn more and more.

I am seeing Richard's sample databases. He is not relating tables using DATABASE TOOLS AND RELATIONSHIPS.Is it not necessary to relate tables using Database Tools and Relatioships when we design a database. Please clear my doubt. It is too much itching my head.

Thanks in advance.

Regards to all.

Ravi Chandiran

---

Reply from Alex Hedley:

Access is clever if you name the linking Fields with the same name so ClientID as PK in ClientT then ClientID as FK in AddressT when you pull both tables into a Query it will try and auto join those Fields as the names match.
The Relationships window just forces this incase you haven't named them the same, or don't want to forget which Fields join.
There is a Seminar which goes into it in further detail or search for which courses they are covered.