Subforms not working correctly?

[samjl6]

So I've set up a form for each of my subscribers, with a subform containing the orders they've made.

However, as you might be able to see from the forms I've attached, only 2/6 forms are showing the correct orders for the correct people. The remaining 4 forms are just showing a list of 4 other orders, and it is showing the same order records under different peoples' names, despite me putting each order under each person's individual name and primary key number which is linked to their subscriber number, so I see no reason as to why it isn't working?

The forms I have attached show one record which is containing the correct information (form3), and the other two forms (form1 & form2) show two different records, but which contain the SAME order information (even though each of these people have each only ordered one thing from me...)

How do I solve this? Where have I gone wrong? :banghead:

 

[llkhoutx]

The subforms are not properly linked to the "master or main" form. Verify the the subform "Link Master Fiedld" and "Link Child Field" properties are properly populated.

 

[Mihail]

Show us the tables structures and the relationships

 

[samjl6]

Show us the tables structures and the relationships

See attached for the two tables I am trying to link and the relationships. Is this correct? What else do I need to do?

 

[Mihail]

Try this:
Open the relationships window.
Right click the arrow.
Choose "Edit Relationship"
Press "Join Type" button
Select option 1 ("Only include rows....")
OK.
OK.

Is now working as you expect ?

 

[samjl6]

The subforms are not properly linked to the "master or main" form. Verify the the subform "Link Master Fiedld" and "Link Child Field" properties are properly populated.

Could you talk me through how I would do that?

 

[samjl6]

Try this:
Open the relationships window.
Right click the arrow.
Choose "Edit Relationship"
Press "Join Type" button
Select option 1 ("Only include rows....")
OK.
OK.

Is now working as you expect ?

Okay, I've just tried, but nope, still coming up with like 5 of the same records for different people...

 

[Mihail]

Sorry for you.
Your DB is so simple... for sure me or other one can tweak the issue in minutes.
Unfortunately I can't do this without to have your DB.
So, if you agree, remove the confidential information from the DB and post it here.
I use Access 2007 so, for me, you should convert your DB in this version of Access.

 

[samjl6]

Not to worry all!

I've managed to fix the problem! After having an old friend who works with databases look at it, he suggested changing the source type of the subform to the table itself (despite someone telling me to create it as a subform on another forum question that I'd posted) and then I just changed the master and child fields to the ID number, and it's worked perfectly!

Thank you all for your help, I really appreciate it!