1:n relationship

[flux]

Hey there, I am currently struggling to create a proper 1:n relationship. I want to link the table "Termine" (Appointments) with the table "Kreditinstitut" (Bank). Both tables are linked with "BLZ/F-BLZ" (Bank number). However, there are no entries in the table "Termine" for "F-BLZ".

In the end I want to create a subform of the table Termine where new appointments can be entered and will be linked to the bank. However, there is no proper connection with my current approach. When I enter a appointment in the subform it does show it for every bank and not only for the specific one.
I did the exact same thing with the two other tables in the image and it works fine only this table is grinding my gears.




Hope one of you can help me with my problem. Thank you!

[Welshgasman]

Have you created the correct master and child properties for the subform control?

[Bob Fitz]

Have you set the "Link Master Fields" and the "Link Childs Fields" properties of the sub form correctly?
BTW I notice you have a field called "ID" in table "Kreditinstitut". That name is often used for an Auto-Number type field. If it is an Auto-Number field, why don't you either use that as the Primary Key or delete it.

[flux]

Thank you so much! That was the problem

Best regards