Whenever you build a new Table - do you just think about the fields that relate to its main topic?   What about the notion of relationships, and possibly bringing in fields from other tables that could be foreign keys - and also, potentially sending fields you make in this new Table BACK to other tables?   Now that I have a slightly better grasp on Access   this seems to be a pretty daunting process  - How do your approach building a new Table?

---

Reply from Alex Hedley:

The Relationships Seminar would be a handy one to take to get a better understanding of this.

In Beginner Level 1 Rich discusses Database Design and advises that you should step away from the computer and write down what you need on Index cards.
You can then plan out what data you have and how it relates to each other.
You have to take into account what data you want to store, and see how it relates to other items in your db, do you have an example we could run through of what you want make?