Problem with a look-up in a subform

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:

Have a look: https://www.mediafire.com/file/b4p5155c1y8bhoq/Headshots.zip/file
This is a Base document with a HSQLDB embedded.
The picture names are stored in a separate table linked through a 1-to-1 relation (one or zero pics for each person). For simplicity, the pics are stored in the same directory, so you don’t need to fiddle with any paths.
The picture control belongs to a subform, linking the pictures to the parent form by the common person ID. A double-click on the picture control opens a file picker dialog to add a new image record (if there is no picture record) or modify an existing image if the person ID points to an existing record. After picking a table, the save button saves the new/modified record. The cancel button discards the record. The delete button deletes an existing picture record from the pictures table.

Thank you but I fail to see how that will help my solution.

I fail to see how to help without a document.

Blockquote I fail to see how to help without a document.

Obviously I am unable to send the database as it contains private information within it.

What would you actually need?

IF (and only if) you have a database embedded in the Base document:

  1. Make a copy of the document.
  2. X all strings.
UPDATE "table" set "text column" = 'X'

or simply delete the text columns where they are not involved in relations.
ALTER TABLE "table" DROP COLUMN "text column"
What remains is dates and numbers without context.

Main form with list of design titles
|-> Subform with list of published designs
|-> Subform with list of images
|-----> Sub-subform with selected image
|-----> Sub-subform with details of selected product
|-----> Sub-subform with website

No, the form wizard hardly creates any useful forms.

ask117245.odb (22.5 KB)