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