Complicated database form

Hi. I have a complicated (for me!) database and form. Below is a screenshot of relationships

I have a form (form2-By Subject) based on tbl-Subjects (grid). This has a subform grid based on tbl-Tutorials and there is a further subform based on a qry.

I click on subject and it shows tutorials in grid. Click on tutorial and it shows details.
All works well except for 1 record. Records are correct in tables but when clicking subject it will not show the tutorial. All others are fine. This record is correct in tables.

Difficult to explain so I have uploaded database so you can see what I have done - and hopefully find what I’ve done wrong!!

Download database: https://123club.co.uk/tutorials.zip

Which one?

@keme1 3D in the subject. It should be showing Tutorial ID 5 (Photoshop Fun in 3D),

Only a look on the relationships:
“tbl-Tutorials” should be the main form. It is linked 1:n to subform “tbl-Subjects”. “tbl-Subject_List” is content of a listbox in “tbl-Subjects”. Don’t know why you created this table “tbl-Subject_List”, which only contains strings, which will also be saved in “tbl-Subjects”, but this is the construction you will need.

“tbl-Tutorials” will contain 3 Listboxes for “tbl-Tutors”, “tbl-Artists” and “tbl-Curses”.

@RobertG Thank you. Must admit I’m a bit confused.

Yes, I do have a main form for tutorials - no problem with that.

However, I also have a form for subjects so that I can see a list of all subjects then click on one and see a list of tutorials for that subject.

I have a “tbl-Subject_List” as I need a ‘look-up’ table for the “tbl-Subjects”

I don’t see how your suggested construction will work or help me.

If you have the time to download and look at my database, you might understand my needs and the actual problem I am having.

Tutorials - Copy.odb (83.9 KB)

The form wizard does not even cover the essentials. For instance, the wizard never creates any list boxes.
I changed the primary key of the subjects and the subjects list. See relations window.

My form includes data from all tables in editable subforms.