Problem with form and subform - master and child fields problem

[eurojourney]

Hello,



I have made some changes to my database based on suggestions found in different forums. I have now a main form and subform - the main populates a table named People and the subform a table name PeopleContactMethods. When I do a query to pull the people's name and contact info I get a blank. I thought the Child field and Master field were correct but now I suspect they aren't. I am attaching the link for the database with this thread for whom ever has a chance to take a look at it. Does my relationship chart looks good and makes sense?

I want to be able to pull the contact and names into a query. This is simple stuff so excuse my limited knowledge in this area, I just started to learn this stuff.

Thank you in advance for all the help.

Jorge

You can download the database here: http://www.motojourney.com/j%20milton%20vr374.accdb

Again thank you!!!

[Access_Blaster]

Hi eurojourney,

Everybody doesn't have Access 2007 if you convert to 2000 - 2003 you may get more input.



Richard

[eurojourney]

Ok, thank you, I will change it...