You said not to use lookups in tables.  How about using them in Forms?

Also, are there times when using a lookup in a table is okay (assuming SQL Server is not in the database's future)?  For instance, when the value is something very simple such as a 1, 2 or 3 in a rating system.  Do you really want to create a new table just for this?

---

Reply from Richard Rost:

It's a general rule of thumb, but like I said in the video, there are exceptions. If you're sure you're never going to upgrade to SQL Server, and you're pretty sure you're not going to add options in the future, then go ahead. It's my STRONG recommendation, but not a rule.