I am trying to make a set of cascading list box lookup fields.

If I were going to do it on a form it would be easier, I could VBA to do it. But I'm trying to do it in the table design, and not having much luck I would think it could be done via rowsource in the lookup section for a listbox field


Any help or insight or even the answer "NO it can't be done" would be useful if that truly is the answer

Lee

You can't do it at the table level, nor should you. I do NOT recommend using lookup fields on the table level. Users should never have direct access to tables anyway.

Why is everyone so against lookup fields?

This article explains why

The Access Web - The Evils of Lookup Fields in Tables (http://www.mvps.org/access/lookupfields.htm)

Also, as I said, users should NEVER have direct access to tables. So there is really no reason to use them.