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 this forum. 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 form 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

 

[PNGBill]

I haven't downloaded the file as it is quite big for a sample.

Try getting your query to work first.
Does it return all the data you would expect in the SubForm ?

TablePeople has PersonID (example)

Your Query Data should include PersonID and then have all of the details for each person as fields on each record of your query. One Record for each Person in PeopleTable.

When your query works, then so should your SubForm.

The link would be Master PersonID and Child PersonID (they don't have to have the same name be the same data in the control (field) on the forms)

Check your MainForm and SubForm properties. Sometimes a property on one or both can cause the whole thing to go to custard.

Your SubForm may well be Continuous but doesn't have to be.

 

[eurojourney]

Ok, I did a querry of my table named "People" using the following fields: People ID, Title, Name, Second Name, Last Name, Job Position, Company and PeopleContactMethods ID, which is the field that has the one-to-many relation (this field being the one with the infinity sign in the relationship chart) with the field by the same name in the table "PeopleContactMethods" (this happens to be the primary key in this table). The result is the contents of table "People" but the field PeopleContactMethods ID is empty, it does not have the 1,2,3,4... order found in the table "PeopleContactMethods" in the field by the same name. What am I doing wrong? the relationship chart should have taken care of this issue right? I don't know what am I supposed to do.

Also, from the answer provided I gather that the name of the master and child field is the same and refers to the same table? I thought I knew but now I am uncertain regarding the logic behind the Master/Child fields proper setup.

Thank you for all the help so far!!!

Jorge