Here are my relations
I have a form for tbl-Designs. On that I have a sub-form for tbl-published.
I have Product as a listbox looking up from tbl-ProductList and that works well.
I then have a listbox for Website looking up from tbl-WebsiteList, however, it does not show the list.
The form: