Results 1 to 3 of 3
  1. #1
    eurojourney is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2010
    Posts
    2

    Problem with form and subform - master and child fields problem

    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!!!

  2. #2
    Join Date
    May 2010
    Posts
    339
    Hi eurojourney,

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



    Richard

  3. #3
    eurojourney is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2010
    Posts
    2
    Ok, thank you, I will change it...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Link Master Field and Link Child Field
    By evander in forum Forms
    Replies: 2
    Last Post: 05-25-2010, 09:13 PM
  2. Replies: 0
    Last Post: 12-16-2009, 01:14 PM
  3. Parent/Child subform
    By Jerry8989 in forum Forms
    Replies: 1
    Last Post: 09-18-2009, 07:27 AM
  4. problem with subform
    By dimension in forum Forms
    Replies: 1
    Last Post: 05-28-2009, 05:32 PM
  5. problem in splitting Date and time fields
    By swaroop1012 in forum Queries
    Replies: 1
    Last Post: 11-22-2008, 11:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums