What's the difference of doing this with a combo box or using the lookup & relationship option on the field types?

---

Reply from Richard Rost:

If you're referring to the Lookup table field, I addressed those in Beginner 8 and I'll talk a lot more about them again in Expert 7. They're not good to use for several reasons, mostly because they DE-normalize your database. They're a "crutch" that the Access development team through in there so that novice users could still have lookups without REALLY learning how to create multi-table lookups. When you get to VBA programming they become a nightmare. Again, I explain ALL of the details in Access Expert 7.