Richard, I have been watching Expert 1 over and over and just not getting it.  Instead of customers, contacts, and vehicles, we have fields (literal), which are owned by farms, which are owned by growers, which reside in a state.  I have created separate tables for all of them, but when I try to build my relationships they multiply exponentially (maybe not the right term).  Any advice?

---

Reply from Alex Hedley:

Try building them up a query at a time.
Join your first two tables to get your result.
Then create a new query with a table joined to a query and so forth.